>>>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.