DB2 graphic  QMF Version 8

Writing correlation names

The correlation name must be unique within the query and must appear in two places:

Names used for correlation names in queries are arbitrary. Choose any name up to 128 characters long. It must not duplicate other words in the query or any SQL reserved word.

If you use correlation names and several table names, separate the items in the list with commas. For example:

FROM Q.ORG XXX, Q.APPLICANT, Q.STAFF YYY

You might need correlation names even without a subquery, as in the following example.


Go to the previous page Go to the next page

Downloads | Library | Support | Support Policy | Terms of use | Feedback
Copyright IBM Corporation 1982,2004 Copyright IBM Corporation 1982, 2004
timestamp Last updated: March, 2004