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

1 vote150 views1 answer
Set autoincrement to 0
SQL
1 vote133 views2 answers
Sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) unable to open database file
SQL
0 vote193 views1 answer
Mysql extract day from date leading zero
SQL
10 votes140 views3 answers
Sql limit results
SQL
0 vote158 views1 answer
Soql user profile
SQL
2 votes200 views1 answer
Oracle trace session
SQL
2 votes159 views1 answer
Postgresql format date dd/mm/yyyy
SQL
0 vote143 views1 answer
Add plugins to mysql workbench
SQL
1 vote160 views1 answer
Mysql select from outside
SQL
0 vote141 views1 answer
Allow all local clients (local socket connections) to connect to the kodekloud_db1
SQL