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 vote213 views1 answer
How to make full text search dynamic in mysql
SQL
4 votes198 views4 answers
Sqlite describe table
SQL
1 vote198 views1 answer
Primary key reset in SQL database
SQL
0 vote200 views1 answer
Replace sqlalchemy
SQL
0 vote208 views1 answer
How to query without duplicate rows in sql
SQL
0 vote214 views2 answers
Create row number in sql
SQL
32 votes217 views6 answers
How to change column name in sql
SQL
11 votes200 views2 answers
Import sql file laravel cmd
SQL
0 vote218 views1 answer
Mysql timediff
SQL
0 vote252 views1 answer
How to rename a database in tsql
SQL