Yes --

A view or cursor -- joining several tables is one approach in a SQL select statement.

You can also establish relations between different tables (1:1 or 1:many) through the SET RELATION TO capability of the older FP data manipulation language.

Jay