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

22 votes253 views4 answers
Date format mysql
SQL
11 votes229 views1 answer
Oracle view source
SQL
18 votes270 views3 answers
Get the list of all tables in sql server
SQL
103 votes594 views2 answers
Sql server LIKE '%%'
SQL
0 vote196 views1 answer
Get a list of tables and the primary key
SQL
0 vote200 views1 answer
Bitmap join index
SQL
39 votes302 views5 answers
Sql drop column
SQL
2 votes212 views2 answers
How to rename column name in sql server using query
SQL
0 vote196 views1 answer
Mysql create index lost connection
SQL
0 vote208 views1 answer
Mysql min value row
SQL