RE: query question

[Doug Johnson <djohnson@xxxxxxxxxxxxx>]

Finucci, Steven, Eric, James, Bill, Rob

Thanks to you all for your prompt replies.  I was able to get what I wanted
from the file with your suggestions.

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)

 -----Original Message-----
From:   Bill Erhardt [mailto:ERHARDT@BaldwinHQ.com]
Sent:   Friday, September 28, 2001 10:45 AM
To:     'midrange-l@midrange.com'
Subject:        RE: query question

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.