Link Left Outer Join Operation Syntax for Available Databases (Magic xpa 3.x)
The Link Left Outer Join definition syntax for each available DBMS is described in the table below.
|
|
|
|
|
MSSQL, DB2, and ODBC
|
SELECT {column list} FROM main_table LEFT OUTER JOIN linked_table ON (link_condition)
|
SELECT Dname, Ename FROM departments a LEFT OUTER JOIN employees b ON (a.deptno=b.deptno)
|
|
Oracle
|
SELECT {column list} FROM main_table, linked_table WHERE main_table.column=linked_table.column
|
SELECT Dname, Ename FROM departments a, employees b WHERE a.deptno=b.deptno(+)
|
In the Data View Editor, you can select the Link Outer Join option for the link regardless of the Main Source. Magic xpa opens the table and retrieves the linked data as a Link Query.
Note: A Link Join operation cannot be used on a Web Service database.
