joe26 wrote:Is this because foundsets are ONLY single tables with relations pulling the other data from tables as needed? Whereas SQL queries and Datasets are not strictly adhering to a single table?

Correct.When using a query in order to retrieve particular records in a foundset, you also only need to add the pk column in the result.

So in case you need both, either retrieve the result via databaseManager.getDatasetByQuery, or get the foundset of jobs and retrieve the city via a relationship.The first one will return data a lot faster, since it doesn't return all columns and doesn't have to do the additional query as a result of using a relation.