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 vote141 views4 answers
Restart MySQL
SQL
1 vote142 views3 answers
What is union in sql
SQL
0 vote156 views1 answer
Duplicate value unique constraint mysql error
SQL
0 vote156 views1 answer
Select odd records sql
SQL
0 vote159 views1 answer
On delete set default
SQL
1 vote138 views1 answer
Found option without preceding group in config file: /etc/mysql/mariadb.conf.d/50-server.cnf at line: 1
SQL
12 votes137 views4 answers
Mysql ifnull
SQL
1 vote148 views1 answer
Stored procedure return value
SQL
0 vote163 views1 answer
Sql quary stuf
SQL
0 vote141 views1 answer
Sql with example
SQL