Sybase ADAPTIVE SERVER IQ 12.4.0 - Manual (Page 29)

Adaptive Server IQ 12.4.0 Default
Release Bulletin for Digital UNIX 29
Default ON
Description This option reports a syntax error for those queries containing outer joins that
have ambiguous syntax due to the presence of duplicate correlation names on
a null-supplying table.
The following join clause illustrates the kind of query that is reported.
( R left outer join T , T join S on ( C1 ) )
where C1 is a condition. If the option is set to ON, this query is interpreted as
follows.
( R left outer join T on ( C1 ) ) join S on ( C2 )
where C1 and C2 are conditions.
9.4.5 Support for joins between stores or databases
This section clarifies current support for joins between stores or between
databases.
Any joins within a given IQ database are supported. This means that you can
join any system or user tables in the Catalog Store with any tables in the IQ
Store, in any order.
Joins of IQ tables with tables in an Adaptive Server Enterprise database are
supported under the following conditions:
• On UNIX platforms, the IQ database must be the remote database, and the
Adaptive Server Enterprise database must be the local database. In other
words, on ASE you must add the IQ server a remote server, and define the
IQ tables as proxy tables.
• On Windows NT, the IQ database can be either the local database or the
remote database.