SQL : SELECT * FROM (tbl_lms_courses INNER JOIN tbl_lms_coursepricelist ON tbl_lms_courses.CourseListId = tbl_lms_coursepricelist.CoursePriceListId INNER JOIN tbl_lms_venues ON tbl_lms_courses.VenueId = tbl_lms_venues.VenueId INNER JOIN tblprovincecodes ON tbl_lms_venues.ProvinceId = tblprovincecodes.Code) WHERE tbl_lms_coursepricelist.CourseTypeId = 1 AND tbl_lms_courses.CourseStatusId <> 4 ORDER BY StartDate<br />Query failed : Unknown column 'tbl_lms_courses.CourseListId' in 'on clause'