The following query can run on MySQL 4.1 but can not on MySQL 5.0.x:
SELECT c.*, rst.starttimenameFROM tblcourse c, tblcourse_category_extra ceLEFT JOIN tblref_starttime rst ON rst.starttimeid = c.starttimeidWHERE ce.courseid = c.courseidORDER BY c.approveddate DESC
Anyone can help to explain?
Thanks.