Breaking News: Grepper is joining You.com. Read the official announcement!

RIGHT and FULL OUTER JOINs are not currently supported

Innocent Iguana answered on January 19, 2024 Popularity 1/10 Helpfulness 8/10

answer RIGHT and FULL OUTER JOINs are not currently supported

RIGHT and FULL OUTER JOINs are not currently supported

Comment

-- workaround : RIGHT JOIN = use LEFT JOIN
 SELECT left_t.firstname, right_t.lastname FROM right_t LEFT JOIN left_t ON 
 left_t.firstname=right_t.firstname;
 
-- workaround : FULL JOIN = use UNION
SELECT left_t.firstname, right_t.lastname FROM left_t LEFT JOIN right_t ON 
 left_t.firstname=right_t.firstname
 union 
 SELECT left_t.firstname, right_t.lastname FROM right_t LEFT JOIN left_t ON 
 left_t.firstname=right_t.firstname;

Popularity 1/10 Helpfulness 8/10 Language sql

Source: stackoverflow.com

Tags: sql

Link to this answer
Share Copy Link