failed: SELECT * FROM (business,location,contactdetails) LEFT JOIN subcat on business.lwCat = subcat.subCat_id WHERE business.bs_id = exeter-photos.htm AND contactdetails.lc_id = location.lc_id AND contactdetails.bs_id=exeter-photos.htm