AbrahamA 3/1/2013 2:06:07 PM

Query to find mismatched PO vendors

How would I write a sql script to find it the vendor id is different between 2 po tables?  Need to find this – POP10110 shows a different Vendorid for one PO than the vendor id in POP10100.  I know there is one, but want to find if there are any more…..I think it is easy, but my brain won’t go there. 

 

Version: GP 2010
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