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 vote330 views1 answer
How to check which table has data in mysql
SQL
0 vote310 views1 answer
Learn sqlite dart
SQL
0 vote301 views1 answer
Sub blocks in sql
SQL
1 vote320 views1 answer
Postgres check for foreign key
SQL
0 vote289 views1 answer
Oracle list dblink
SQL
2 votes310 views1 answer
Sql create database
SQL
1 vote331 views1 answer
How to ckeck that email is present in databse in mysqli
SQL
0 vote341 views1 answer
How to move a columns location in mysql
SQL
0 vote326 views1 answer
Last date for each user sql
SQL
1 vote271 views1 answer
Ms sql how to see active job current run time
SQL