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

6 votes112 views2 answers
Mysql convert timestamp to date
SQL
0 vote105 views1 answer
Sql character index
SQL
0 vote114 views1 answer
Work around for mutating problem in Oracle Triggers. Please check it out.
SQL
13 votes159 views4 answers
Mysql remove foreign key constraint
SQL
1 vote136 views4 answers
How to check table in postgresql from terminal
SQL
0 vote114 views1 answer
Select the date 30 days less that the todays date sql request
SQL
0 vote113 views1 answer
Linebreak sql
SQL
1 vote113 views1 answer
CREATE DATABASE db; SyntaxError: Unexpected identifier
SQL
0 vote111 views1 answer
Codeigniter dbforge add index
SQL
0 vote104 views1 answer
Selecting Data in SQL - Select Data
SQL