instead of the select *, explicitily list the fields you require from the
master then add a group by clause listing the same fields
BUT if a master row has 2 details which one do you want it to return



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

-----Original Message-----
From: rambabu.piridi@... [mailto:rambabu.piridi@...]
Sent: 25 July 2006 11:31
To: nick@...
Subject: RE: [firebird-support] Badly need your Help-Very urgent



Where do i have to add the first/skip in the query.

I did like this:



select FIRST 10 SKIP 10 * from USR_BASIC_INFO BASIC LEFT OUTER JOIN
USR_EXTENSION_INFO EXTENSIN ON BASIC.USR_ID=EXTENSIN.USR_ID

Actually i have foreign key relationship with these two tables. So in case
if my master row has two details then i am getting two results of the same
master row which i dont want. even if i do join but for every one master rwo
the result set should consist of one result only.

Thanks n Regards,
=============================
Rambabu Piridi.
Software Engineer,
Wipro Technologies,
Madhapur,
Hyderabad.

e-Mail : <mailto:rambabu.piridi@...> rambabu.piridi@...
Mobile: 99491 83303.
==============================


_____

From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Nick
Sent: Tuesday, July 25, 2006 1:15 PM
To: firebird-support@yahoogroups.com
Subject: RE: [firebird-support] Badly need your Help-Very urgent



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@ <mailto:firebird-support%40yahoogroups.com>

yahoogroups.com

> [mailto:firebird-support@ <mailto:firebird-support%40yahoogroups.com>

yahoogroups.com] On Behalf Of

> rambabu.piridi@ <mailto:rambabu.piridi%40wipro.com> wipro.com
> Sent: 25 July 2006 08:15
> To: firebird-support@ <mailto:firebird-support%40yahoogroups.com>

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.

The information contained in this electronic message and any attachments to
this message are intended for the exclusive use of the addressee(s) and may
contain proprietary, confidential or privileged information. If you are not
the intended recipient, you should not disseminate, distribute or copy this
e-mail. Please notify the sender immediately and destroy all copies of this
message and any attachments.

WARNING: Computer viruses can be transmitted via email. The recipient should
check this email and any attachments for the presence of viruses. The
company accepts no liability for any damage caused by any virus transmitted
by this email.

www.wipro.com




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