Unknown column 'TRE_PageStyle' in 'on clause' select * from TBL_Architecture ,TBL_ArchRelation left join TBL_PageStyle on TRE_PageStyle = PS_ID where PCR_CatID = '6' and PCR_ParentCatID = TRE_ID order by TRE_Order asc