YamatjiMarlpa

Simple SQL Sub Query

Discussion created by YamatjiMarlpa on Mar 25, 2013
Hi

Having trouble with very simple SQL Sub Query.

Desktop help suggests finding records NOT IN a table with a similar fields follows a simple form like:

"COUNTRY_NAME" NOT IN (SELECT "COUNTRY_NAME" FROM indep_countries)

Having just come from 5 years of using MapInfo this is indeed the same form and works as expected in that software.

However trying to form the same query in ArcMap 10.1 (using Geodatabase Feature Classes) continues to give me an error that it can't find the TABLES. It doesn't matter which of the two tables attribute tables I open and try and build the query I get the same response.

I must be making a very simple syntax error here but can't discover what. Any help appreciated.

Clive

Outcomes