Hi Gerard,
Could you possibly accomplish what you are after by setting up views in your database and building business objects for the views? The other possibility might be to reference other business objects from within the primary business object.
Linda

>Hi.
>Is there a way in .net (C#) to select to a temporary Cursor and then use this as the source
> of another select e.g.
>
>Select * ,.....from Tablea Into Table Temp1
>Select * from Temp1 into Table Temp2
>Select * from Temp2 into table Temp3...etc
>
>The above selects are just examples
>Each select is more complicated , with numerous fields and some
> of the selects are done for grouping purposes.
>
>Any help appreciated.
>regards,
>Gerard