|
|
Posted by Jens on 11/01/05 21:10
select customers.customerid, customers.country,
orders.orderid, orders.orderdate, orderdetails. sum(unitprice) as
TotalSales
from customers, orderdetails --Leave this guy away as you are already
using it in the Join syntax
/*There is no relationaship in a join syntax with orderdetails, as this
is Order id, add the following:
Inner Join orderdetails on Oderdetails.orderId = orders.orderid
*/
left join orders on customers.customerid = orders.customerid
where orderdate > '11/1/4'
and country <> 'USA'
and unitprice > 0
and orderid > 346544
group by orderid
order by orderid
HTH, Jens Suessmeyer.
Navigation:
[Reply to this message]
|