开发者

multiple condition in join

开发者 https://www.devze.com 2023-01-20 02:51 出处:网络
how c开发者_高级运维an i use two or more condition on join? i want to replace this query with join version of it:

how c开发者_高级运维an i use two or more condition on join? i want to replace this query with join version of it:

select * 
from t1,t2 
where t1.a=t2.b and t1.c=t2.d and t1.e=t2.f

how could it be?


This should work

select * 
from t1
join t2 
on t1.a = t2.b and t1.c = t2.d and t1.e = t2.f
0

精彩评论

暂无评论...
验证码 换一张
取 消