Click to See Complete Forum and Search --> : sql group by and SUM


polynaux
04-05-2007, 10:32 AM
Hi Guys,

I have the following two tables:

http://group3-1.at.vwdhosting.net/Philip/sqlproblem.jpg

now I would like to write a query that matches every DateCreated in the PurchaseOrder Table with a Quarter in the Overheads Table.
Moreoever TotalPrice and Overheads should be added.
e.g.



Quarter DateCreated AddNew
01.01.2006 | 02.02.2006 |TotalPrice + Overheads from first Quarter

..

1.10.2006 ..


I would be very happy if I can get some suggestions,

greetings

Philip

polynaux
04-06-2007, 12:46 PM
problem is solved thanks