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 vote196 views1 answer
Selecting all columns from table sql database
SQL
1 vote174 views1 answer
How to subtract from the value of a table in sql
SQL
10 votes174 views4 answers
Drop primary key
SQL
1 vote176 views1 answer
Rermove categories woocommerce sql
SQL
6 votes180 views4 answers
Mysql group by date
SQL
51 votes284 views6 answers
Opera gx
SQL
3 votes166 views2 answers
Current year sql
SQL
2 votes200 views4 answers
How to find 2nd highest salary in mysql
SQL
1 vote182 views1 answer
Oracle create program if no exists
SQL
2 votes195 views3 answers
Sql server: how to concatenate column data using comma
SQL