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