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

3 votes286 views1 answer
Insert into table from another table mysql
SQL
10 votes310 views1 answer
User_dependencies
SQL
0 vote328 views1 answer
How to add a Try/Catch to SQL Stored Procedure
SQL
0 vote283 views1 answer
Get all employees if name ends with in sql
SQL
0 vote317 views1 answer
My sql data file extention
SQL
3 votes302 views1 answer
Mysql replace string in table
SQL
5 votes314 views5 answers
Find max number in sql
SQL
2 votes299 views1 answer
Oracle trace session
SQL
0 vote253 views1 answer
Finish transaction sql
SQL
0 vote311 views1 answer
QUERY JPQL
SQL