[ http://issues.apache.org/jira/browse/DERBY-39?page=comments#action_12365812 ]
Satheesh Bandaram commented on DERBY-39: ---------------------------------------- I tried both the SQL statements above (in two different comments) on DB2 that I have access to. Both were rejected there too... Erik already mentioned MS SQL doesn't like this syntax. > Strange error in JOIN ON clause > ------------------------------- > > Key: DERBY-39 > URL: http://issues.apache.org/jira/browse/DERBY-39 > Project: Derby > Type: Bug > Components: SQL, Newcomer > Versions: 10.0.2.0 > Reporter: Erik Bengtson > > The exception: > --------------------------------------- > Error: An ON clause associated with a JOIN operator is not valid. > --------------------------------------- > happens when I run the below SQL script: > --------------------------------------- > SELECT > THIS.DOSSIERTEMPLATE_ID > FROM DOSSIERTEMPLATE THIS, > ENTITLEMENT UNBOUND_ENTITLE > INNER JOIN > ENTITLEMENT II > ON UNBOUND_ENTITLE.ENTITLEMENT_ID = II.ENTITLEMENT_ID > INNER JOIN > DOSSIERTEMPLATERESOURCE BB > ON II.ENTITLED_TO_RESOURCE_ID_OID = BB.DOSSIERTEMPLATERESOURCE_ID > INNER JOIN > I18N THIS_LABEL > ON THIS.LABEL_I18N_ID_OID = THIS_LABEL.I18N_ID > --------------------------------------- > It works fine if I run without the LABEL join > --------------------------------------- > SELECT > THIS.DOSSIERTEMPLATE_ID > FROM DOSSIERTEMPLATE THIS, > ENTITLEMENT UNBOUND_ENTITLE > INNER JOIN > ENTITLEMENT II > ON UNBOUND_ENTITLE.ENTITLEMENT_ID = II.ENTITLEMENT_ID > INNER JOIN > DOSSIERTEMPLATERESOURCE BB > ON II.ENTITLED_TO_RESOURCE_ID_OID = BB.DOSSIERTEMPLATERESOURCE_ID > --------------------------------------- > The column LABEL_I18N_ID_OID is BIGINT and has a FK to I18N_ID, which is > BIGINT as well -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira
