sql - can we replace full join with union of left and right join? why not? -


can replace full join union of left , right join? if no,why?

'yes' if t1 , t2 sets (no duplicated rows), otherwise answer 'no'.

create table t1 (i int); create table t2 (i int);  insert t1 values (1); insert t1 values (2); insert t1 values (2);  insert t2 values (3); 

full join

select * t1 full join t2 on t1.i=t2.i  order 1,2 

1   (null) 2   2 2   2 (null)  3 

union

select * t1 left join  t2 on t1.i=t2.i union select * t1 right join t2 on t1.i=t2.i order 1,2 

1   (null) 2   2 (null)  3   

union all

select * t1 left join  t2 on t1.i=t2.i union select * t1 right join t2 on t1.i=t2.i order 1,2 

1   (null) 2   2 2   2 2   2 2   2 (null)  3 

Comments

Popular posts from this blog

php - How to add and update images or image url in Volusion using Volusion API -

Laravel mail error `Swift_TransportException in StreamBuffer.php line 269: Connection could not be established with host smtp.gmail.com [ #0]` -

c# SetCompatibleTextRenderingDefault must be called before the first -