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 vote386 views1 answer
Ora-01109 database not open in oracle 19c
SQL
0 vote357 views1 answer
Helptext in sql
SQL
-1 vote294 views3 answers
Ubuntu install mssql
SQL
0 vote338 views1 answer
Oracle search columns in schema
SQL
3 votes379 views5 answers
Sql select
SQL
1 vote341 views1 answer
Sql server 2016 reseed identity
SQL
1 vote375 views3 answers
Connect to mysql c# connection string C#
SQL
0 vote342 views1 answer
Sql select with apostrohpe
SQL
1 vote358 views1 answer
Generate random data postgresql
SQL
0 vote364 views1 answer
Sql date between one week
SQL