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
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