Steve Sel count(*) from vendor whe vendorn not in (sel vendorn from master)
Buddy -------------------------- Sent from my BlackBerry Wireless Handheld -----Original Message----- From: [email protected] <[email protected]> To: RBG7-L Mailing List <[email protected]> Sent: Wed May 04 14:00:54 2005 Subject: [RBG7-L] - Verification of Command results possibilities Here is the question. I have two tables. 1. Vendor 2. Master In the table vendor there is a column named: Vendorn In the Table Master there are columns named: Vendorn and Vendor2 Here is the issue: I am trying to determine how many vendor records are in the vendor table that do not relate to the master table. I think my method is correct, but I want a second opinion. Now finally the question. Will the command below give me the actual number of records that have no relation to the master table. I know this is simple stuff, stuff but this is a critical issue and I want to double check myself. I have to get accurate results. R>compute count vendorn from vendor where vendorn not in (sel vendorn from master) and vendorn not in (sel vendor2 from master) Your help is appreciated Steve Breen
