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
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