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

12 votes368 views3 answers
Install sqlite driver ubuntu
SQL
0 vote395 views1 answer
Sql query to get contact form 7 fields
SQL
12 votes413 views6 answers
Distinct in sql server
SQL
22 votes402 views4 answers
Date format mysql
SQL
12 votes358 views4 answers
Mysql version
SQL
0 vote381 views1 answer
Databricks install odbc driver connect to sql server
SQL
3 votes363 views1 answer
Oracle function return
SQL
0 vote306 views1 answer
Get last run query sql server
SQL
0 vote342 views1 answer
Sqlite select split string
SQL
2 votes346 views1 answer
Oracle table size
SQL