#20 parser fails with brackets in FROM

[Carsten Schuette]

this statement does not work:

select
adress.adrnr,adress.adrgr,adress.suchname,staadr.vk as
Umsatz
from ("adressen\adress" adress
left outer join "adressen\praadrvb" praadrvb on
adress.adrnr=praadrvb.adrnr)
left outer join "adressen\staadr" staadr on
(adress.adrnr=staadr.adrnr) and (monat=13) and
(jahr=2002)

when I remove the brackets after FROM and the one
before th second LEFT OUTER JOIN, it works. The parser
should be able to handle this.

This one works and returns the same:

select
adress.adrnr,adress.adrgr,adress.suchname,staadr.vk as
Umsatz
from "adressen\adress" adress
left outer join "adressen\praadrvb" praadrvb on
adress.adrnr=praadrvb.adrnr
left outer join "adressen\staadr" staadr on
(adress.adrnr=staadr.adrnr) and (monat=13) and
(jahr=2002)

[b2]

Logged In: YES
user_id=1096017

This is a great problem for me.
I want to reformat SQL statements created by MSAccess but
MSAccess always produces joins starting with many '(' for
example:

select * from ((x left join y on (...)) left join z on (...)) left
join a on (...)