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 vote243 views1 answer
Sql server roles and users
SQL
0 vote195 views1 answer
Count char in java
SQL
0 vote250 views1 answer
Kill a pid redshift
SQL
4 votes262 views3 answers
Sql drop database if exists
SQL
0 vote254 views1 answer
How to print some string in mysql
SQL
5 votes237 views2 answers
Sql conn
SQL
0 vote310 views2 answers
Mysql insert rows to another database
SQL
0 vote237 views1 answer
Drush run sql select
SQL
1 vote237 views1 answer
Moodle query first user access
SQL
0 vote251 views1 answer
Postgresql replace html tags from string
SQL