MySQL Forums
Forum List  »  General

Re: #1241 - Operand should contain 1 column(s) - help?
Posted by: Peter Brawley
Date: May 30, 2018 12:40PM

Is this what you mean?

select t.userid, t.firstname, t.lastname
from tblcontacts t
join customer c on t.userid=c.customerid && t.firstname=c.initials && t.lastname=c.surname;

If not, show the results of ...

Show Create Table tblcontacts;

Show Create table customer;

And, why in the world is customer data being copied in the tbcontacts table!? Primary keys render such redundancy a waste of resources and (your) time.

Options: ReplyQuote


Subject
Written By
Posted
Re: #1241 - Operand should contain 1 column(s) - help?
May 30, 2018 12:40PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.