Previous Topic: SyntaxNext Topic: Implied Relationship


Joining Objects and Conditions

The keyword WHERE connects any OBJECT to any CONDITION. You can join the OBJECT:

FILE "QA1#" (which selects all the files on computer QA1)

to the CONDITION:

FILE_SIZE > 500KB (which matches all the files larger than 500 KB)

using the query:

FILE "QA1#" WHERE FILE_SIZE > 500 KB

The result is all files on computer QA1 that are larger than 500 KB.

The attribute in the CONDITION (FILE_SIZE) is also an attribute of the object FILE.