Revolving around the core of technology
| Document ID: | 780 |
|---|---|
| Subject: | Example of using OUTER JOINS |
| Creation date: | 7/29/09 3:24 PM |
| Last modified on: | 7/29/09 3:24 PM |
Many back-end databases support OUTER JOINS. However, the syntax is quite different from one database to another. If you are not sure what is the correct syntax used by your back-end server, you can use a generic syntax that will work with any database.
Consider the following query.
select EMP.ENAME
from {oj SCOTT.DEPT DEPT LEFT OUTER JOIN SCOTT.EMP EMP ON DEPT.DEPTNO = EMP.DEPTNO }
The above query uses a generic format that can be used by any ODBC client, including WinSQL. This generic format is converted into database specific format by the ODBC driver before sending it to the database.
Any generic query can be converted in to its native format by highlighting the query, clicking the right mouse button and selecting Get native SQL from the pop-up menu.
Posted by Anonymous on 7/8/10 4:13 AM
Do you have a helpful tip related to this document that you'd like to share with other users?