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

4 votes331 views1 answer
Mysql timestamp in laravel migration
SQL
0 vote330 views1 answer
Delete a record from a table sqlite3
SQL
1 vote319 views1 answer
Set statistics on in ssms
SQL
5 votes323 views1 answer
Ignore duplicate rows in sqlite
SQL
1 vote346 views1 answer
Mysql strict_trans_tables
SQL
12 votes325 views5 answers
Sql primary key
SQL
0 vote334 views1 answer
Mysql repair a table
SQL
1 vote332 views1 answer
Sql sort column by date
SQL
3 votes459 views1 answer
How to get yesterday date in sql
SQL
0 vote364 views1 answer
Sqlcl format
SQL