Using QMF

Writing correlation names

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

• In the FROM clause of the main query
• In the WHERE clause of the subquery

Names used for correlation names in queries are arbitrary. Choose any name up to 18 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.