
January 25th, 2003, 03:13 AM
|
|
Registered User
|
|
Join Date: Apr 2007
Posts: 22,309
Time spent in forums: < 1 sec
Reputation Power: 24
|
|
|
Help on Query
I have 3 tables: category,budget,transaction
The budget and transaction tables have categoryId and amount fields. They both have a one to many relationship from the category table. I need to return CategoryID,Budget.Amt,Transaction.Amt. Each row is a different CategoryId with the sum of the budget amts for that CategoryId and the sum of the transaction amounts for that CategoryId.
How do I write this query?
Thanks in advance
|