Please, what to use to collect related data from several tables into a
dataset component in a client application ? Possibilities I can see are
1 either use a dataset component with DSQL select statement and add
lookup fields to a dataset object for data from related tables,
2 or use DSQL select with join(s) to get resulting rowset with all
needed columns at once
3 or is it better to use selectable stored procedure or view which
join the tables and give the resulting rowset ?

It seems to me that procedures and views have advatages over DSQL
approach but I don't have experiences. What about performance,
variable sorting of the result set ?

If it matters, I am using Delphi with FB2 and trying DAC libraries
like FIBPlus, IBDAC and IBObjects.

Boro