using modifier

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.


command using dict file.reference {item.list} {selection.criteria} {sort.criteria}
{modifiers} {(options)}


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