Hi Radek,

> could you tell me please where this use of the brackets is documented?
> I mean those between a keyword "join" and "on".

I get it from the old IB6 Language Reference (can't find anymore were to download it):

<joined_table> =
<tableref> <join_type> JOIN <tableref>
ON <search_condition> | (<joined_table>)


Watch the last part of the <joined_table> section.

Regards,
Arno Brinkman
ABVisie

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
General database development support:
http://www.databasedevelopmentforum.com

Firebird open source database (based on IB-OE) with many SQL-99 features :
http://www.firebirdsql.org
http://www.firebirdsql.info
http://www.fingerbird.de/
http://www.comunidade-firebird.org/

Support list for Firebird and Interbase users :
firebird-support@yahoogroups.com

Nederlandse firebird nieuwsgroep :
news://newsgroups.firebirdsql.info