|< < 37 > >|

Outerjoins

Right outer join


select *
from F right join P using (p_id)

F right 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
2	NULL	NULL	P only

|< < 37 > >|