Excluding cases in one table that are in second table.


No cake for spunky
I have two tables. One is a subset of the other (call the subset table 2 and the larger table 2 is a subset of is table 1). I want to exclude from the larger table 1 the values in table 2.

Anyone have any idea how to do it. I figured a join would do it, but none that I have ever worked of will. I really want to do something like Select * when record not in table 2. But I don't know a filter that will do that either...


No cake for spunky
This works

proc sql;
create table work."02st2"n as select *
from work.'02st1'n s
where not exists (select * from work.d02true0 t where s.VRID = t.vrid)