>>>>Edward,
>>>>
>>>>It still could be done with views, but you'll need two.
>>>>
>>>>The first one:
>>>>

CREATE SQL VIEW lv_level1 AS SELECT Table2.SeqNo FROM Table2 WHERE Table2.id = ?vp_Id

>>>>
>>>>The second one:
>>>>

 CREATE SQL VIEW LEVEL2 AS SELECT Table1.* FROM Table1 INNER JOIN lv_Level1 ON ;
>>>>    Table1.LinkField = Lv_Level1.SeqNo

>>>
>>>José,
>>>I did not say that it cannot be done with views. What I said is that it might be done faster with cursors.
>>
>>OK, no problem. And views of views have their problems too: the second view will always contain the orginal values, not the buffered content of the first view.
>>
>>As to speed, I did not make a comparison, but I would be interested if someone has results to share.
>>
>>José
>
>SEEK/SKIP/INSERT (i.e. non-SQL) loop is faster in some situations (you select few records by one filter from large table on network with SET DELETED ON) and it assumes using of cursors.


This seems to be the way to go. Thanks!

Elyse