|< < 38 > >|

Outerjoins

Full outer join


select *
from F full join P using (p_id)

F full join P

p_id	f_id	f_label	p_label
1	11	P and F	P and F
1	12	P and F	P and F
NULL	20	F only	NULL
2	NULL	NULL	P only

|< < 38 > >|