It is probably not going to happen with the current database performance, but this would normally accomplish the task:
select b.hl_name, b.ll_name from backups b where b.node_name='your node' and b.state=inactive_version and (b.hl_name || b.ll_name) not in (select a.hl_name || a.ll_name from backups a where a.node_name='your node' and a.state=active_version) I tried it on a single node and it did not find what I was looking for. I am going to turn in a problem record on it because it should work. Paul D. Seay, Jr. Technical Specialist Naptheon Inc. 757-688-8180 -----Original Message----- From: Williams, Tim P {PBSG} [mailto:[EMAIL PROTECTED]] Sent: Friday, September 20, 2002 1:59 PM To: [EMAIL PROTECTED] Subject: SQL - punting for help Ok. This one is teasing me...puzzeling... trying to get, from the backups table files that ONLY are inactive (if the file has an active copy, I don't want to have this in the output). have tried...myself... anyone? have tried state<>state, but this doesn't work.... ? Thanks tim