SQL : joins

select <field_list> from Table1 A 
inner join Table2 B on A.key = B.key
;
select <field_list> from Table1 A 
left join Table2 B on A.key = B.key
;
select <field_list> from Table1 A 
right join Table2 B on A.key = B.key
;
select <field_list> from Table1 A 
left join Table2 B on A.key = B.key
where B.key is null
;
select <field_list> from Table1 A 
right join Table2 B on A.key = B.key
where A.key is null
;
select <field_list> from Table1 A 
full outer join Table2 B on A.key = B.key
;
select <field_list> from Table1 A 
full outer join Table2 B on A.key = B.key
where A.key is null or B.key is null

;

请画出A , B 交集图