如果没有ON关键字,您是否可以拥有INNER JOIN? [英] Can you have an INNER JOIN without the ON keyword?
本文介绍了如果没有ON关键字,您是否可以拥有INNER JOIN?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
在调试一些Oracle代码时,我遇到了以下查询:
While debugging into some Oracle code, I came across this query:
SELECT TPM_TASK.TASKID FROM TPM_GROUP
INNER JOIN TPM_USERGROUPS ON TPM_GROUP.GROUPID = TPM_USERGROUPS.GROUPID
INNER JOIN TPM_TASK
INNER JOIN TPM_GROUPTASKS ON TPM_TASK.TASKID = TPM_GROUPTASKS.TASKID
INNER JOIN TPM_PROJECTVERSION ON TPM_TASK.PROJECTID = TPM_PROJECTVERSION.PROJECTID AND TPM_TASK.VERSIONID = TPM_PROJECTVERSION.VERSIONID
INNER JOIN TPM_TASKSTAGE ON TPM_TASK.STAGEID = TPM_TASKSTAGE.STAGEID
INNER JOIN TPM_PROJECTSTAGE ON TPM_PROJECTVERSION.STAGEID = TPM_PROJECTSTAGE.STAGEID
ON TPM_GROUP.GROUPID = TPM_GROUPTASKS.GROUPID
我被这行弄糊涂了:
INNER JOIN TPM_TASK
我以前没有看到没有ON
子句的JOIN
.这行也令人困惑:
I haven't seen a JOIN
without an ON
clause before. Also confusing is the line:
ON TPM_GROUP.GROUPID = TPM_GROUPTASKS.GROUPID
这似乎是一个随机的ON
子句,没有任何匹配的JOIN
.查询运行时没有任何错误,并返回了一堆数据,因此很明显,语法是完全有效的.有人可以阐明这里到底发生了什么吗?
This seems like a random ON
clause without any matching JOIN
. The query runs without any errors, and returns a bunch of data, so obvious the syntax is perfectly valid. Can someone shed some light on exactly what's going on here?
推荐答案
小宇宙...昨天我遇到了一个生成此语法的工具,颇为困惑.
Small universe... I ran across a tool generating this syntax yesterday and was rather flummoxed.
显然,
FROM a
INNER JOIN b
INNER JOIN c ON (b.id = c.id)
ON (a.id = c.id)
等效于嵌套子查询
FROM a
INNER JOIN (SELECT <<list of columns>>
FROM b
INNER JOIN c ON (b.id=c.id)) c
ON (a.id = c.id)
这篇关于如果没有ON关键字,您是否可以拥有INNER JOIN?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文