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 votes143 views2 answers
Postgres alter table owner
SQL
0 vote129 views1 answer
ORACLE SUBSTRING SYNTAX
SQL
9 votes150 views6 answers
Check constraint in sql
SQL
17 votes153 views2 answers
Mysql date to string
SQL
1 vote137 views1 answer
Host 127.0 0.1 is not allowed to connect to this mysql server
SQL
2 votes136 views2 answers
Postgresql get table names
SQL
0 vote146 views1 answer
Sql waitfor
SQL
0 vote128 views1 answer
Authentication in sql server
SQL
0 vote129 views1 answer
Oracle sql developer closed connection
SQL
-1 vote128 views8 answers
Create Trigger in phpMyAdmin
SQL