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

3 votes283 views2 answers
Sqlite print all column names
SQL
0 vote302 views1 answer
Get only one row in mysql
SQL
0 vote271 views1 answer
Sql case when exists in another table
SQL
7 votes305 views6 answers
Mysql group concat
SQL
0 vote284 views1 answer
Create tables from xsd to sql server database c#
SQL
1 vote267 views1 answer
Sql oracle update multiple rows
SQL
0 vote306 views1 answer
Time data type in mysql
SQL
2 votes290 views1 answer
Set auto increment from 1
SQL
0 vote330 views1 answer
Postgres docs /copy metacomand
SQL
6 votes267 views2 answers
Can't connect to local mysql server through socket
SQL