Answers for "can we apply left join on union of two tables"

SQL
0

UNION ALL LEFT JOIN

SELECT
    comments.*, users.company, users.contact_person, users.email
    FROM
        comments
    LEFT JOIN users ON users.user_id = comments.user_id
    WHERE
        comment_id = %s
UNION ALL
SELECT activity.*, users.company, users.contact_person, users.email
    FROM
        activity
    LEFT JOIN users ON users.user_id = activity.user_id
    WHERE
        comment_id = %s
ORDER BY
    timestamp ASC
Posted by: Guest on November-17-2020

Code answers related to "can we apply left join on union of two tables"

Code answers related to "SQL"

Browse Popular Code Answers by Language