Select c.*, ci.name cityname, ci.country citycountry FROM jetsetreport as c Join cities as ci on (c.cityID = ci.cityID) Where 1 = 1 AND id = 222 Order By id desc Invalid query: Select c.*, ci.name cityname, ci.country citycountry FROM jetsetreport as c Join cities as ci on (c.cityID = ci.cityID) Where 1 = 1 AND id = 222 Order By id desc