Maybe

select distinct(po) from purchaseorders

will do ?

----- Original Message -----
From: "Terry V." <byakko@...>
To: <IBObjects@yahoogroups.com>
Sent: Monday, August 22, 2005 10:14 AM
Subject: [IBO] Redundant records in a result set.


> Hello all,
>
>
>
> 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.
>
>
>
> Also, I hope that I am not to far off topic my question deals more
> generally
> with SQL and not necessarily IBO.
>
>
>
> Regards,
>
> Terry V.
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
>
> ___________________________________________________________________________
> 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
>
>
>
>
>
>
>