SQL - punting for help

[Williams, Tim P {PBSG}]

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