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

Source: stackoverflow.com

Similar codes

0 vote100 views1 answer
Postegresql update to null
SQL
0 vote120 views1 answer
Sql query to get column names and data types in sql server
SQL
0 vote102 views1 answer
Mysql add comment to column
SQL
5 votes124 views1 answer
Oracle asynchronous query
SQL
1 vote117 views1 answer
Sql server insert into temp table
SQL
0 vote102 views5 answers
ABC TO FLEX BATTLE IM POOR
SQL
3 votes105 views2 answers
Mysql create timestamp column
SQL
0 vote107 views1 answer
What is delimiter in mysql
SQL
1 vote108 views1 answer
Postgres convert exisiting column to text
SQL
5 votes100 views3 answers
Day of week postgresql
SQL