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

2 votes267 views1 answer
Mysql virtual column
SQL
0 vote267 views1 answer
Query to remove duplicate rows from a table
SQL
-1 vote272 views1 answer
Extract Data from SQL Server into XML Format
SQL
0 vote283 views1 answer
How to check database engine in mysql
SQL
0 vote276 views1 answer
Sqlalchemy orm duplicate
SQL
0 vote251 views1 answer
Difference between cross apply and inner join
SQL
0 vote263 views1 answer
Tsql generate rows
SQL
0 vote288 views1 answer
Postgres multiple left join causing duplicates jsonb_agg
SQL
0 vote261 views1 answer
Sql select merge multiple values
SQL
0 vote256 views1 answer
Flask sqlalchemy update row
SQL