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

3 votes215 views3 answers
Mysql order by list
SQL
1 vote240 views1 answer
Mysql connect bash
SQL
0 vote224 views1 answer
Should I use the datetime or timestamp data type in MySQL?
SQL
16 votes228 views3 answers
Get count of duplicate records
SQL
0 vote188 views1 answer
Calculate date and convert to yearsmysql
SQL
0 vote202 views1 answer
Aktor yang pernah terlibat lebih dari 3 film di sql
SQL
0 vote178 views1 answer
Create api project in visual studio 2019 and sql server
SQL
0 vote226 views1 answer
Sql string contains case sensitive
SQL
0 vote194 views1 answer
Mysql disable query caching
SQL
0 vote200 views1 answer
Change permission to database mysql
SQL