Share
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:
USE
SELECT
FROM
GROUP BY

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

Attachments

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.

$2.19