#######
内联接(等值)
use demo;
select *
from t1 inner join t2
on t1.id = t2.id
或
select *
from t1 join t2
on t1.id = t2.id
或
select *
from t1 , t2
where t1.id = t2.id
内联接(>联接)
select *
from t1 inner join t2
on t1.id < t2.id
或
select *
from t1 , t2
where t1.id < t2.id
内联接(自然联接)
select *
from t1 natural join t2
where t1.id = t2.id
或
select *
from t1 natural join t2
自然联接不可以用on,只能用where,而且想比较的两个字段名必须是一样的
#######
外连接(左外联接)
select *
from t1 left outer join t2
on t1.id = t2.id
或
select *
from t1 left join t2
on t1.id = t2.id
不可以没有on
外连接(右外联接)
select *
from t1 right outer join t2
on t1.id = t2.id
或
select *
from t1 right join t2
on t1.id = t2.id
交叉联接(笛卡儿积)
select *
from t1 cross join t2
或
select *
from t1 , t2