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 vote123 views1 answer
Calculate age in sql
SQL
0 vote112 views1 answer
Sql put two columns into one
SQL
52 votes194 views6 answers
Rename column sql
SQL
0 vote117 views1 answer
Why we have to set the password for my sql server
SQL
4 votes115 views1 answer
Restart for pg_hba.conf file
SQL
0 vote115 views1 answer
Drop all triggers oracle
SQL
0 vote125 views1 answer
Sql join on a subquery
SQL
0 vote130 views1 answer
Which lock mode is not available in sql
SQL
0 vote125 views1 answer
Create a view in sqlite
SQL
0 vote129 views1 answer
Groupby sort sql hive
SQL