Posted by triciam on 11/01/05 20:38

I am using this query but it�s 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 I�m getting:
ables or functions �orders� and �orders� have the same exposed names.
Use correlation names to distinguish them.
I�m 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

[Back to original message]