🚀 go-pugleaf

In SQL like systems one can select records from a file based on  the values
of a field in a connected file.

For example, something like: 
SELECT {all records} 
FROM {the file} PARTS
WHERE PARTS.SupplierID = SUPPLIER.ID {this links the files} AND
SUPPLIER.City='New York' {this selects the records I want}

Note that no looping nor explicit IF THEN ELSE statements are used.

Is something similar possible in 4th Dimension ? How do you do it ?


any help would be much appreciated !

-Henk

Have a nice day!