dbartley 9/20/2013 9:25:48 AM

SQL Help

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)

Version: All
Section: SQL Scripts


Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
3