|
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) |
