|
|
Posted by triciam on 11/01/05 20:38
I am using this query but its not working, please help
select customers.customerid, customers.country,
orders.orderid, orders.orderdate, orderdetails. sum(unitprice) as
TotalSales
from customers, orders, orderdetails
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
This is the error message that Im getting:
ables or functions orders and orders have the same exposed names.
Use correlation names to distinguish them.
Im not sure how to make this work......... Thank You Tricia :)
--
Posted using the http://www.dbforumz.com interface, at author's request
Articles individually checked for conformance to usenet standards
Topic URL: http://www.dbforumz.com/SQL-help-ftopict267876.html
Visit Topic URL to contact author (reg. req'd). Report abuse: http://www.dbforumz.com/eform.php?p=920152
Navigation:
[Reply to this message]
|