vbnetcoder
asked on
expected value lookup for a field
To give an example of have a table called Table1 with a field called [country] (an abreviation)
I also have a table called Countries with the abbreviation listed.
I want to write a procedure to return all the records where the table1 - country field contains a value that is NOT in the Countries table.
How?
I also have a table called Countries with the abbreviation listed.
I want to write a procedure to return all the records where the table1 - country field contains a value that is NOT in the Countries table.
How?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
ty
FROM Table1 LEFT JOIN tblCountries on Table1.Country = tblCountries.Country
WHERE tblCountries.Country IS NULL