|< < 35 > >|

Outerjoins

Ordinary (inner) join


select *
from F join P using (p_id)

F 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

|< < 35 > >|