[LightImage]

Примерно так:

SELECT *
FROM (Kontragent K INNER JOIN Gorod G ON K.idGorod=G.id) INNER JOIN Region R ON K.idRegion=R.id