union all left join

Solutions on MaxInterview for union all left join by the best coders in the world

Search
showing results for - "union all left join"
Mía
21 Jan 2017
1SELECT
2    comments.*, users.company, users.contact_person, users.email
3    FROM
4        comments
5    LEFT JOIN users ON users.user_id = comments.user_id
6    WHERE
7        comment_id = %s
8UNION ALL
9SELECT activity.*, users.company, users.contact_person, users.email
10    FROM
11        activity
12    LEFT JOIN users ON users.user_id = activity.user_id
13    WHERE
14        comment_id = %s
15ORDER BY
16    timestamp ASC
17
source
similar questions
union vs union all in sqlunion all in sqlsql unionsql server union all examplesql right joinunion in sqlunion allleft join in sql with 3 tablesoracle sql union tables with different columnssql left outer join vs left joinright join sqlhow to use select union and loopleft join sqlselect distinct after joinsql left join 2 tablesdifference between join vs unionsql left joinjoin vs unionunion and union all in sql server
queries leading to this page
two left join and union in one querysql union vs joincan we apply left join on union of two tablessql left join right join unionunion all vs inner joinunion all and joinunion vs left outer joinsql left join union right join resultunion or left joinunion all left joinmysql union all left joinhow to use union with left join in sqlunion all vs joinunion left joinleft join union right joinsql left join union right join sql union left joinfull join using left join union right joinunion join sqlunion all left join