rambabu.piridi@... wrote:

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

Sure, but first I'll suggest that you think about what you're
doing. In a relational database, all attributes of a record
are represented by data in the record. Storage order is not
data. So, when you say "rows from 20 to 40", you must mean
rows with the value of some field between 20 and 40.

select <some fields>
from users u
left outer join user_properties up
on <some condition>
where u.<field> between 20 and 40


You probably assume that there is a position associated with
the order of storage of records. That's an unsafe assumption,
deliberately so because different databases optimize access
in different ways - with Firebird, if you delete a row, it
will be replaced with a row stored much later.

Regards,


Ann


Regards,


Ann