Just add the first/skip clause to your existing query

--
Nick
-----We Solve your Computer Problems---
UNIX, C, Panther, Ingres, Interbase, Firebird - Available Shortly

> -----Original Message-----
> From: firebird-support@yahoogroups.com
> [mailto:firebird-support@yahoogroups.com] On Behalf Of
> rambabu.piridi@...
> Sent: 25 July 2006 08:15
> To: firebird-support@yahoogroups.com
> Subject: [firebird-support] Badly need your Help-Very urgent
>
>
> I have two tables. User and User Properties.
> I am doing table "User" left outer join Table "UserProperties".
>
> but i want to do the join some thing like this:
> Select rows from 20 to 40 from table User and then doing the
> join with these rows with the table UserProperties.
>
> Can you please suggest the query for this.