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 vote129 views1 answer
What is SQL data store?
SQL
0 vote130 views1 answer
Inserted row count tsql
SQL
2 votes138 views1 answer
Import large .sql files into lampp
SQL
1 vote130 views1 answer
Sqlstate[imssp]: the active result for the query contains no fields.
SQL
0 vote145 views1 answer
Safe mysql
SQL
0 vote124 views2 answers
Update information in a mysql column
SQL
0 vote151 views1 answer
Convert LDAP Epoch to Date
SQL
1 vote126 views1 answer
Mamp mysql path mac
SQL
10 votes129 views6 answers
Between sql
SQL
0 vote136 views1 answer
Take sql dump in to file
SQL