>>Hi.
>>
>>I think that this should be a simple one for the experts.
>>
>>I have a lookup table (Table_A) that stores a numeric code and a full description. I have another table (Table_B) that stores one of those codes in a field (Item).
>>
>>What I want to do is create a view (or SQL if a view can't do it) that lists all rows from the Table_A (lookup table) that are not used in Table_B. IOW, identify the potentially useless records in the lookup table.
>>
>
>

>SELECT * ;
>  FROM Table_A ;
>  WHERE Item NOT IN ;
>    (SELECT Item IN Table_B)
>

>
>You can make a view of this, too, if you want.
>
>Tamar

Thanks Tamar. I'll give it a try.