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

4 votes146 views2 answers
Sql offset
SQL
0 vote149 views1 answer
How to set up an anonymous function to variable in swift
SQL
0 vote142 views1 answer
Mysql count unique in group statement
SQL
0 vote130 views1 answer
FIND AVERAGE SALARY EARNER IN SQL
SQL
7 votes148 views1 answer
Query delete duplicates
SQL
0 vote150 views1 answer
Set engine to innodb
SQL
18 votes155 views6 answers
Laravel form validation
SQL
3 votes178 views2 answers
Brew restart mysql
SQL
8 votes150 views1 answer
Script to add datafile to tablespace
SQL
0 vote127 views1 answer
Mysql database is not starting in xampp
SQL