You can decide what tables to put together and what fields to pull out.
This problem requires joining two tables together and using "group by" to create sensible query. The Chart_of_Accounts table holds a list of the different accounts in the database. Each account is linked to a property in the Property table using the Property_ID key.
For our query we will find the sum of the balances for ...
In this solution I demonstrate how to join two tables together with a SQL query. The query also uses the GROUP BY function.