2006/7/25, rambabu.piridi@... <rambabu.piridi@...>:

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

Does

select first 21 skip 19 * from user left outer join userproperties [...]

Work for you?