|< < 36 > >|

Outerjoins

Left outer join


select *
from F left join P using (p_id)

F left 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	30	F only	NULL

|< < 36 > >|