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

2 votes150 views1 answer
Change primary key sql
SQL
0 vote182 views2 answers
What is rownum in oracle
SQL
4 votes164 views1 answer
SQL find text in SP
SQL
22 votes158 views3 answers
How to join three tables in sql using joins
SQL
0 vote225 views1 answer
Sqlite schema structure of a relational database
SQL
1 vote169 views1 answer
How to get previous year from sysdate in oracle
SQL
0 vote216 views1 answer
Dynamic where clause in sql server stored procedure
SQL
7 votes155 views2 answers
What is sql clause
SQL
3 votes141 views1 answer
Sql select all
SQL
18 votes146 views3 answers
Mysql add column with default value
SQL