My guess would be more along the lines of





Select * from user left outer join userproperties on . where user.userid in
(Select first 21 skip 19 userID from User)



Graeme

_____

2006/7/25, rambabu.piridi@ <mailto:rambabu.piridi%40wipro.com> wipro.com
<rambabu.piridi@ <mailto:rambabu.piridi%40wipro.com> wipro.com>:

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





[Non-text portions of this message have been removed]