Hi peter,

thanks for your reply.

the query gives the duplicate values in the table,

but my task is to check against the codes table and list which are not valid product codes...