Ron,
Do you have a single table, with all those columns in it? If so, it would be
something like this, to get a list of the files to be saved from boxes to be
destroyed today:
SET VAR vDestroyDate DATE = .#DATE
SELECT f1.ssn, f1.client_id, f1.box_no +
FROM file_information f1
WHERE (box_destruct_date = .vDestroyDate) +
and exists +
(SELECT ssn FROM file_information f2 +
WHERE (f2.box_destruct_date > f1.box_destructdate) +
AND (f2.ssn = f1.ssn))
Bill
On Thu, 18 Sep 2003 20:56:09 -0600, Plateautel.net wrote:
>Yes, it's me, and thanks to all. It is good to be back.
>I track the clients by name, ssn, client_id, box_no, box_destruct_date
>When the destruction date has arrived for the box, I need to look at all the
>other boxes to see if any of the clients in the box have volume files in any
>other box. If not, I can destroy the file. If there is a later file, I
>need to remove the file from the box to be destroyed and put that file with
>the more recent file. I hope this helps.
