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.

TIA

Mike