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 vote180 views1 answer
Sql replace id with name from another table
SQL
13 votes197 views1 answer
Select count of distinct values sql
SQL
1 vote183 views1 answer
Oracle explain plan
SQL
0 vote180 views2 answers
Create row number in sql
SQL
0 vote185 views1 answer
How to use group_concat in sql server
SQL
0 vote187 views1 answer
Flask sqlalchemy decimal
SQL
0 vote184 views1 answer
Python list from sql
SQL
0 vote193 views1 answer
Sql select where more than one record exists
SQL
1 vote191 views1 answer
Failed to stop mysqld.service: Unit mysqld.service not loaded.
SQL
0 vote276 views1 answer
SqlMessage: "Table 'Friends' already exists",
SQL