what I have tried so far is the following

select Y.DESCRIPTION from Y minus select UPPER (X.NAME) from X;

the problem with this is that if a town appears in more than one county then it does not check the town and county combination from file X is the same as in file Y , so if I have ballyboggin in county dublin on file Y but on file X it matches to a ballyboggin that is in county cork the above will not report this...

I have two tables of town names , in one table the spellings are correct(table x) whilst on the other there are some mistakes (table y).

I would like to run a query that will read table y and tell me all entries on it which do not have a match on table x - the towns must also be in the same county, detailes below

CREATE TABLE X
(
ID NUMBER,
NAME VARCHAR2(100 BYTE),...