How can I combine the 2 queries below so that it looks for vendors that don’t exist in the PM30200 & PM20000 at one time? I think I need a union on the 2 tables. I basically want to search for vendors that have never had activity in the open or history tables.
select vendorid from pm00200 where vendorid not in
(select vendorid from PM30200)
select vendorid from pm00200 where vendorid not in
(select vendorid from PM20000)