Help with a complex query

Hi!

I have a big problem with a query. The situation is this. I have an acount table with a unique acountno. for each row. To this table I have two detail tables, one with usage and one with budget.

For each acount there can be several rows for both usage and budget. I would like to get a total for both the usage and the budget for a specific acount in one query, how can I accomplish this?

-- 
Casper Thrane
Systemdeveloper
Benau A/S