比如
select
XX
FROM A
INNER JOIN B
ON A.key1 = B.key1
AND A.key2 = B.key2
还有
select
XX
FROM A
INNER JOIN B
ON (A.key1 = B.key1
AND A.key2 = B.key2)
这两种写法有差别吗?
...全文
1343打赏收藏
突然想到一个问题 关于join on条件的
比如 select XX FROM A INNER JOIN B ON A.key1 = B.key1 AND A.key2 = B.key2 还有 select XX FROM A INNER JOIN B ON (A.key1 = B.key1 AND A.key2 = B.key2) 这两种写法有差别吗?