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 vote238 views1 answer
Sqlite explain plan
SQL
3 votes215 views1 answer
Sql cast to integer
SQL
0 vote245 views1 answer
Mysql command line top 10
SQL
24 votes222 views5 answers
Sql server insert into select
SQL
0 vote258 views1 answer
Drop a view in sqlite
SQL
3 votes214 views1 answer
V$session not found in oracle
SQL
0 vote232 views1 answer
Query to remove duplicate rows from a table
SQL
27 votes283 views3 answers
Mysql delete row
SQL
6 votes217 views1 answer
SQL insert all columns
SQL
0 vote225 views1 answer
Insufficient memory to excute the sql query
SQL