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 votes192 views3 answers
NOT NULL SQL
SQL
0 vote159 views2 answers
How to get json data mysql
SQL
0 vote233 views1 answer
Mac os zsh: command not found: mysql
SQL
0 vote179 views2 answers
Advantages of stored procedures sql
SQL
0 vote172 views1 answer
Mysql docker image arjun
SQL
0 vote168 views1 answer
Normalization in database 2nd normal form
SQL
12 votes214 views6 answers
How to install sqlite3 in python
SQL
2 votes215 views1 answer
Select a certain number of entries from select mysql
SQL
3 votes165 views3 answers
Create a view postgres
SQL
0 vote188 views1 answer
How to define a non primary composite key in sql
SQL