SELECT tbl_person.name , tc1.title , tc2.title FROM tbl_person JOIN tbl_city tc1 ON tbl_person.CurrentCityID = tc1.id JOIN tbl_city tc2 ON tbl_person.LastCityID = tc2.id
SELECT tbl_person.name , C.title AS CurrentTitle, L.title AS LastCity FROM tbl_person JOIN tbl_city C ON tbl_person.CurrentCityID = C.id JOIN tbl_city L ON tbl_person.LastCityID = L.id
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)