外连接之左连接(left join 或left outer join):select A.c1,B.c2 from A left join B on A.c3=B.c3;
外连接之右连接(right join 或 right outer join): select A.c1,B.c2 from A right join B on A.c3=B.c3;
外连接之完全外部连接(full join 或 full outer join):select A.c1,B.c2 from A full join B on A.c3=B.c3;
内连接(join 或者inner join ): select A.c1,B.c2 from A join B on A.c3=B.c3;
θ联接(Theta Join): select A.c1,B.c2 from A join B on A.c3!=B.c3;
交叉连接(Cross join):没有用where子句的交叉连接将产生连接所涉及的笛卡尔积第一个表的行数乘以第二个表的行数等于笛卡尔积和结果集的大小;直接将一个数据源中的每个行与另一个数据源的每个行一一匹配
select * from A cross join B;
如果有条件(where)
select * from A cross join B where A. 条件列名= B.条件列名
扩展:结果集联合查询(Union 或 Union All)
Union联合
select A.c1,A.c2 from A
union
select B.c1,B.c2 from B
注意:联合查询上下的查询个数和类型必须对应一致,union默认将重复数据去掉。如果不让他去掉,则用union all
Union All 联合
select A.c1,A.c2 from A
union all
select B.c1,B.c2 from B