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 vote195 views2 answers
Psql commande \gset
SQL
3 votes215 views3 answers
Illuminate database queryexception could not find driver (sql select * from
SQL
0 vote291 views1 answer
Mysql collation portugues brasil
SQL
0 vote216 views1 answer
How to do a function to return row type from a table in pl/sql
SQL
1 vote206 views2 answers
How to combine 2 tables in MySQL
SQL
0 vote195 views1 answer
Add alternate add column sql
SQL
6 votes186 views4 answers
Delete table sqlite
SQL
0 vote190 views1 answer
Run mssql server terminal
SQL
0 vote229 views1 answer
Wordpress make wp user in db
SQL
-1 vote194 views1 answer
How to switch user in mysql
SQL