Thanks to everyone for the responses. It was exactly what I am looking for
and I'll be sure to check out the other support list.



Cheers,

Terry V.



_____

From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com] On Behalf
Of Lester Caine
Sent: Monday, August 22, 2005 12:03 PM
To: IBObjects@yahoogroups.com
Subject: Re: [IBO] Redundant records in a result set.



Terry V. wrote:

> This is my first post here in this forum and I am glad to be here. My
> question is probably going to be a fairly elementary one. Anyhow, I am
> attempting to pull some information out of a PO table and one of the

records

> is referenced twice, thus it is displayed twice. This redundancy is

unwanted

> and I am wondering how I would filter the data in the SQL statement so

that

> only the first instance of this record shows. Any help would be

appreciated.

SELECT DISTINCT ...

or

SELECT FIRST 1 ....

> Also, I hope that I am not to far off topic my question deals more

generally

> with SQL and not necessarily IBO.

Using the above will probably need some help from the firebird support
list - firebird-support@yahoogroups.com where you will get more SQL type
support ;)

--
Lester Caine
-----------------------------
L.S.Caine Electronic Services


___________________________________________________________________________
IB Objects - direct, complete, custom connectivity to Firebird or InterBase
without the need for BDE, ODBC or any other layer.
___________________________________________________________________________
http://www.ibobjects.com - your IBO community resource for Tech Info papers,
keyword-searchable FAQ, community code contributions and more !




_____

YAHOO! GROUPS LINKS



* Visit your group "IBObjects
<http://groups.yahoo.com/group/IBObjects> " on the web.

* To unsubscribe from this group, send an email to:
IBObjects-unsubscribe@yahoogroups.com
<mailto:IBObjects-unsubscribe@yahoogroups.com?subject=Unsubscribe>

* Your use of Yahoo! Groups is subject to the Yahoo!
<http://docs.yahoo.com/info/terms/> Terms of Service.



_____



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