rgb192
asked on
numerous varchar columns in one row
table has email1 email2 email3
varchar
I want to select the row (name,phoneNumber) for each email
varchar
I want to select the row (name,phoneNumber) for each email
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
this answer is close to the question
because I think a union would work
thank you
because I think a union would work
thank you
ASKER
UNION ALL
SELECT first_name,email2
UNION ALL
SELECT first_name,email3
FROM family
Error Code: 1054. Unknown column 'first_name' in 'field list'