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

11 votes274 views5 answers
How to install sqlite3 python
SQL
0 vote266 views1 answer
Oracle sql date winter time
SQL
-1 vote283 views1 answer
How to dump .csv file into mysql
SQL
2 votes318 views1 answer
How to check if a row is null in sql
SQL
0 vote274 views1 answer
Python connect microsoft sql server
SQL
1 vote267 views1 answer
Caused by: java.lang.IllegalStateException: Cannot load driver class: com.mysql.jdbc.Driver
SQL
0 vote313 views1 answer
Look at running processes redshift
SQL
0 vote297 views1 answer
SQL Server Splitting a string column into multiple rows, while repeating ID column
SQL
0 vote261 views1 answer
How to connect to mysql in ef 6
SQL
0 vote276 views1 answer
How to combine rows in sql server procedure
SQL