RE: query question

[Bill Erhardt <ERHARDT@xxxxxxxxxxxxx>]

This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
--
[ Picked text/plain from multipart/alternative ]
You could concatenate the fields, then sort by and count the occurrences.
Output to a file, then write a second query to read the outputted file
selecting those with a count greater then one.


> -----Original Message-----
> From: Doug Johnson [SMTP:djohnson@Univbkstr.com]
> Sent: Friday, September 28, 2001 11:29 AM
> To:   'midrange-l@midrange.com'
> Subject:      query question
>
>
> Greetings,
>
> I need to find out if records are being posted twice to an inventory
> file-and query is all that I have to work with.
> Is there a way to use query to select records from a file based on the
> fact
> that the data in several fields is identical to the data in those fields
> in
> another record when in fact that combination of fields should be unique in
> the file?
>
> Thanks,
>
> Doug
>
> **********************************************
> DOUGLAS JOHNSON
> System Administrator
> The University Book Store
> 711 State Street
> Madison, WI 53703
>
> djohnson@univbkstr.com
> 608-257-3784
> 608-257-9479 (fax)
>
> _______________________________________________
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
> list
> To post a message email: MIDRANGE-L@midrange.com
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
> or email: MIDRANGE-L-request@midrange.com
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
--