Something like....

SELECT State_ID ;
   FROM Table1 ;
   WHERE State_ID NOT IN (SELECT State_ID ;
                          FROM Table2)

>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