I need some help in writing a sql statement.
I have three tables (Sales, Cust and Product). The sales table contains a
large volume of data and I want to create a sql to group the sales table
then join the resultant to both the Cust and Prod and to have additional
fields selected from the Cust and Prod.
So in effect something like (obviously syntax is wrong)
Select sm.prodno, sm.custno, sum(cost) as costs, sum(sales) as sales,
from Sales SM where sm.date <= date(‘2005-09-01 00:00:00’) Group by
sm.prodno, sm.custno, sm.date ,
(Select prod.desc, prod.code, cust.custno, cust.name from cust, Prod) left
join sm.prodno = prod.code left join sm.custno=cust.custno) …
Any help would be greatly appreciated.
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.344 / Virus Database: 267.11.14/127 - Release Date: 10/10/2005