SELECT *;
from table2;
where abre not in (select abrev from table1)

Agnes

>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