Re: SQL: How to display one record from a file without affecting the others

["Lennon_s_j@xxxxxxxxxxx" <lennon_s_j@xxxxxxxxxxx>]

The DISTINCT keyword may be what you want, as in SELECT DISTINCT ...

Sam

On 4/19/2010 4:19 PM, Peter_Vidal@xxxxxxxx wrote:
> Hi list!
>
> Another SQL challenge (at least for me): I have an SQL SELECT Statement
> with 3 files.  I need to add a 4th one (REQMTS); however, in this file I
> may have more than one record that will match the selection criteria.  I
> just want to have one record and not all of the records that match the
> selection criteria.