SELECT state FROM table2 ;
  WHERE State NOT IN (SELECT state FROM table1)
* or using correlated query
SELECT state FROM table2 ;
  WHERE NOT EXISTS (SELECT state FROM table1 WHERE state = table2.state )

>All I want to do is select records from two tables by looking at one field in each table. I want to find what states in table 2 are not in table 1. What would the SELECT- SQL command look like to do this? THANKS!
>
>For example lets say Table 1 is my working table with state records in it.
>NY
>NJ
>FL
>CA
>TX
>
>Table 2 is a table with all the states in it.
>AL
>AK
>AR
>... and so on
>WV
>WY