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
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 交集图