Yes, there is the MINUS command. This is the opposite of UNION.
So lets say you have Table A and Table B, both same structure
fielda varchar2(10)
fieldb number
That query will return all the records in tableA that are NOT in tableB.
Hope that helps.
For quick answers to questions like this also check out
Ask Tom.
Ask Tom is a guy at Oracle that knows everything. You ask him a question and he'll respond,
usually within the day. I have never had him fail me yet.
Mark