I have a database with two tables:
- “Friends” (Name, CountryID)
- “Countries” (ID, Country)
I want to build a report displaying a list of friends names and relative country (USA, Italy, France…) instead of country ID.
Which formula I have to use in Data field of “Country” Text Box properties?
Is SQL allowed?
I tried SELECT "Country" FROM "Friends" JOIN "Countries" ON "ID" = "CountryID"
but it doesn’t display anything in the report
Thank you!