Explore BrainMass

SQL Query to Join Two Tables

Create a query with the kudler_team_c database I attached.
This query should pull at least two tables together. So it needs to have the following:

You can decide what tables to put together and what fields to pull out.

© BrainMass Inc. brainmass.com July 20, 2018, 5:58 pm ad1c9bdddf


Solution Preview

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 ...

Solution Summary

In this solution I demonstrate how to join two tables together with a SQL query. The query also uses the GROUP BY function.