Link to home
Start Free TrialLog in
Avatar of rgb192
rgb192Flag for United States of America

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
ASKER CERTIFIED SOLUTION
Avatar of Bradley Fox
Bradley Fox
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of rgb192

ASKER

SELECT first_name,email1
UNION ALL
SELECT first_name,email2
UNION ALL
SELECT first_name,email3
FROM family

Error Code: 1054. Unknown column 'first_name' in 'field list'
Avatar of rgb192

ASKER

this answer is close to the question
because I think a union would work


thank you