内连接： select *
from t1,t2
where t1.f1=t2.f1
左外连接：select *
from t1,t2
where t1.f1=t2.f1(+)
右外连接：select *
from t1,t2
where t1.f1(+)=t2.f1
全外连接：select *
from t1
full outer join t2
on t1.f1=t2.f1
扫一扫
1098
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
