The using modifier allows AQL to report on the data in a given file using attribute-defining items from a different file. Only one using connective is allowed in a TCL sentence.
Syntax
command using dict file.reference {item.list} {selection.criteria} {sort.criteria} {modifiers} {(options)} |
Example(s)
In this example, the attribute-defining items name and phone are extracted from the dictionary of the suppliers file, and applied to items in the customers file.
list customers using dict suppliers name phone |
See Also