Help me with a simple query

[flac0]

Table documents
IdDocument
NameDocument
etc

Table documents_items
IdDocument
iditem
price
etc

Table documents_items_tax
IdDocument
IdItem
Tax
etc

For each document i got some items and for each item i got some taxes...

I need to create a query that can sum for each document the total price and total tax but not discriminate by each item and each tax, only the totals for each document

How i can do it...thanks!

 

[dvrobin]

This should do it:

select NameDocument, sum(price), sum(tax) from documents inner join documents_items on documents_items.IdDocument = documents.IdDocument inner join documents_items_tax on documents_items_tax.IdItem = documents_items.IdItem group by NameDocument

Dave Robinder, MCSD