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

1 vote146 views1 answer
Mysql select row with max value group by
SQL
4 votes151 views1 answer
Mac install mysql
SQL
0 vote152 views1 answer
Oracle db timestamp auto add
SQL
0 vote152 views1 answer
Create bdd mysql
SQL
0 vote141 views1 answer
Mysql function variable
SQL
3 votes161 views2 answers
Postgresql select all column names
SQL
37 votes146 views3 answers
Postgresql insert column
SQL
0 vote150 views2 answers
SQL Server Standard
SQL
15 votes144 views4 answers
How to get all tables in sql
SQL
0 vote146 views1 answer
Cartesian product sql
SQL