Ambiguous column name 'CustID'.
Posted on 2008-10-22
I have 2 tables Customer and GiftCerticate both has a column name CustID
am trying to write the below query to check email and dob from Customer and this custid should exist
in giftcertificate table ...
SELECT CustID FROM Customer, GiftCertificate
AND GiftCertificate.CustID = Customer.CustID
but i am getting this error
Ambiguous column name 'CustID'..
please can someone advise