同表内连接查询(自连接)INNER JOIN
SELECT a.* FROM a_sheet a
INNER JOIN
a_sheet b
ON
a.ziduan1 = b.ziduan2
多表连接查询
等值关联(只取交集数)INNER JOIN
SELECT a.*,b.* FROM a_sheet a
INNER JOIN
b_sheet b
ON
a.ziduan1 = b.ziduan2
左关联(左全右跟随)LEFT JOIN
SELECT a.*,b.* FROM a_sheet a
LEFT JOIN
b_sheet b
ON
a.ziduan1 = b.ziduan2
另一种写法:
select * from dept ,employee where dept.deptid=employee.deptid(+)
在(+)计算时,哪个带(+)哪个需要条件符合的,另一个全部的。即放左即右连接,放右即左连接。
右关联(右全左跟随)RIGHT JOIN
SELECT a.*,b.* FROM a_sheet a
RIGHT JOIN
b_sheet b
ON
- ziduan1 = b.ziduan2
全关联(左右皆全,无关联显NULL)FULL JOIN
SELECT a.*,b.* FROM a_sheet a
FULL JOIN
b_sheet b
ON
a.ziduan1 = b.ziduan2
另一种写法:
select * from dept full join employee on 1=1