[OJB-developers] MSAccess problem with multiple non nested joins

[Jakob B. <jbr...@ho...>]

hi oleg,

msaccess has a problem with multiple non nested joins without parentheses:

this query has two NOT NESTED joins, one to tabKonto the other to
tabTelefon:

SELECT DISTINCT
A0.id,A0.vorname,A0.name,A0.adresse,A0.gebDat,A0.test,A0.isBoss,A0.entryDate
,A0.idPartner,A2.tel_nr FROM tabPerson A0 INNER JOIN tabTelefon A2 ON
A0.id=A2.idPerson INNER JOIN tabKonto A1 ON A0.id=A1.idPerson WHERE
(A1.saldo>?) AND A2.tel_nr LIKE ? ORDER BY 10

msaccess can not handle this (Syntax error) , because it needs parentheses
around the first join:
[Microsoft][ODBC Microsoft Access Driver] Syntaxfehler (fehlender Operator)
in Abfrageausdruck 'A0.id=A2.idPerson INNER JOIN tabKonto A1 ON
A0.id=A1.idPerson'.

SELECT DISTINCT
A0.id,A0.vorname,A0.name,A0.adresse,A0.gebDat,A0.test,A0.isBoss,A0.entryDate
,A0.idPartner,A2.tel_nr FROM (tabPerson A0 INNER JOIN tabTelefon A2 ON
A0.id=A2.idPerson) INNER JOIN tabKonto A1 ON A0.id=A1.idPerson WHERE
(A1.saldo>?) AND A2.tel_nr LIKE ? ORDER BY 10

NESTED joins are handled correctly by msaccess! this query has a join from
tabKonto to tabPerson and then to tabTelefon:

SELECT DISTINCT A0.id,A0.idPerson,A0.nummer,A0.saldo FROM tabKonto A0 INNER
JOIN (tabPerson A1 INNER JOIN tabTelefon A2 ON A1.id=A2.idPerson) ON
A0.idPerson=A1.id WHERE A2.tel_nr LIKE ?

greetings jakob