Export a list of User Emails by User_ID

Data & reporting
3

Somehow didn’t know about that. Immediately resolved my issue, thank you very much!

Btw the working query is:

SELECT users.id AS user_id, user_emails.email
FROM users
LEFT JOIN user_emails ON users.id = user_emails.user_id AND user_emails.primary
WHERE users.id IN (/* list of user IDs here, e.g. 1,2,3 */)
1 Like