Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Getting Ambiguous Column Name Error and not sure why

Status
Not open for further replies.

dwg23

Technical User
Oct 21, 2002
151
US
I am running the below statement and getting The following error and am not sure why.
Ambiguous column name 'item'.

select dci.item, dci.scheduleID, dci.customer, c.name, vw.invoicedate
from tblsoDiscountCustomerItem as dci inner join tblarCustomer as c on dci.customer = c.customer
JOIN vwsninvoicelinesales vw ON vw.customer = c.customer
order by item

Thanks.
dwg23
 
Figured it out. the error was coming from the order by item. It should have been order by dci.item
Thanks All!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top