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

1 vote148 views1 answer
Postgresql update auto_increment value
SQL
3 votes180 views2 answers
Sql asc
SQL
0 vote173 views1 answer
Jenkins SQLCMD run
SQL
0 vote209 views1 answer
How to add auto increment primary key
SQL
7 votes176 views4 answers
Lowest salary in sql
SQL
0 vote171 views1 answer
How to reset the database value in SQL server
SQL
0 vote162 views1 answer
Restart postgresql.service Failed to restart postgresql.service: Unit not found.
SQL
5 votes179 views2 answers
Oracle rename table
SQL
-1 vote175 views3 answers
My sql alter table
SQL
3 votes161 views3 answers
Mysql select table names
SQL