Небольшой кусок help


JOIN
You can specify a single table or view, multiple tables, or a single view and multiple tables. When you specify more than one table, the tables are said to be joined.

Syntax
join-definition ::= table-reference [ join-type ] JOIN table-reference ON search-
condition
| table-reference CROSS JOIN table-reference | outer-join-definition
join-type ::= INNER | LEFT [ OUTER ] | RIGHT [ OUTER ] | FULL [ OUTER ] outer-join-definition ::= table-reference outer-join-type JOIN table-reference ON search-condition outer-join-type ::= LEFT [ OUTER ] | RIGHT [ OUTER ] | FULL [ OUTER ]
The following example illustrates a two-table outer join:
SELECT * FROM Person LEFT OUTER JOIN Faculty ON Person.ID
= Faculty.ID

The following example shows an outer join embedded in a vendor string. The "OJ" can be either upper or lower case.
SELECT t1.deptno, ename FROM {OJ emp t2 LEFT OUTER JOIN
dept t1 ON t2.deptno=t1.deptno}

Pervasive.SQL supports two-table outer joins as specified in the Microsoft ODBC Programmer's Reference.
In addition to simple two-table outer joins, Pervasive.SQL supports n-way nested outer joins.
The outer join may or may not be embedded in a vendor string. If a vendor string is used, Pervasive.SQL strips it off and parses the actual outer join text.