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

0 vote200 views1 answer
System.Data.SqlClient.SqlException: 'Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.' SqlDataAdapter
SQL
0 vote225 views1 answer
Set mysql socket file docker windows
SQL
0 vote195 views1 answer
ValueError: A string literal cannot contain NUL (0x00) characters.
SQL
3 votes182 views1 answer
Oracle APEX elapsed time
SQL
0 vote199 views1 answer
Column ' ' in field list is ambiguous
SQL
2 votes212 views1 answer
Sql percentage with % rounded down
SQL
1 vote174 views1 answer
Set id count mysql
SQL
0 vote185 views1 answer
Min:sec datediff mssql
SQL
0 vote192 views1 answer
Join in update query in mysql
SQL
0 vote194 views1 answer
Drop all procedures sql server
SQL