>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

select * from Table1 where state not in (select State from Table2)