Another SQL question

[viktoras d.]

Hi Bob,

no need to write complex queries in rev, create view and then write 
simple query for the view :-)

all the best
Viktoras

Bob Sneidar wrote:
> The idea is to be able to page through large data sets by setting a 
> limit on the number of records I return in the parent cursor, and then 
> only return records in the "relational" cursors whose keys match the 
> parent. I don't want to use the SQL relational system, because frankly 
> writing rev code to build highly complex queries to return data from 
> multiple tables into one cursor on the fly is more trouble than I want 
> to deal with. I wish there was a way in SQL to set up linked cursors 
> for relations, but alas it is what it is.
>