SELECT distinct metroAreaid_FK, suburbId_Fk,'' FROM `tb_MetroAreaSuburbs` S,tb_Properties P LEFT JOIN tb_MasterRecords M on M.id_PK=S.suburbId_Fk where suburbId_Fk=iSuburbId_FK and P.bAdvertisement =1 AND P.bActive =1 and metroAreaid_FK=iAreaId_FK order by metroAreaid_FK,M.vDescription   <br>Unknown column 'S.suburbId_Fk' in 'on clause'