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 votes183 views4 answers
Show databases in sql server
SQL
2 votes162 views1 answer
Ifnull postgres
SQL
1 vote165 views4 answers
Between vs in sql
SQL
2 votes167 views1 answer
Sql server find table name
SQL
0 vote182 views1 answer
Postpresql relation not found
SQL
1 vote188 views1 answer
Name of today sql
SQL
5 votes177 views2 answers
Sql server port number
SQL
0 vote193 views1 answer
Sql delete dastabase
SQL
0 vote179 views2 answers
Database owner can't create new tables postgres
SQL
0 vote171 views1 answer
Sql server manager close connection
SQL