Select some field

BIZ TMS Aurelius
1
Hi,
i have 3 table like this

Tabel tbCountry
id (PK)
name

Tabel tbCity
id (PK)
name
id_country (FK tbCountry)

Tabel tbGuest
id (PK)
name
id_country (FK tbCountry)
id_city (FK tbCity)

how do I display it like in SQL below with Aurelius?

SELECT A.ID,A.NAME,B.NAME AS COUNTRY,C.NAME AS CITY
FROM TBGUEST A
LEFT JOIN TBCOUNTRY B ON (B.ID=A.ID_COUNTRY)
LEFT JOIN TBCITY C ON (C.ID=A.ID_CITY)
2

Just do a 


Guests := Manager.Find<TGuest>.

You will be able to access subjects using associations like:

Country := Guests[0].Country;
City := Guests[0].City;