learningnet
asked on
Ambiguous column name 'CustID'.
Hello Experts,
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
WHERE Customer.CustEmail='test@t est.com'
AND Customer.CustDOB='15/10/19 06'
AND GiftCertificate.CustID = Customer.CustID
but i am getting this error
Ambiguous column name 'CustID'..
please can someone advise
thanks
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
WHERE Customer.CustEmail='test@t
AND Customer.CustDOB='15/10/19
AND GiftCertificate.CustID = Customer.CustID
but i am getting this error
Ambiguous column name 'CustID'..
please can someone advise
thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.