Hi,

I hope that the subject isn't too vague...

I have a table with country codes and names and want to query against
it with a list of codes. The query should return the values, which are
not in the table.

Example:
The table contains: 'de', 'fr', 'it', 'at', 'ch', 'es'
The queried values are: 'de', 'it', 'es', 'pl', 'cz', 'us'
The query should return: 'pl', 'cz', 'us'

I know that there is a way with a subselect, but i don't know how to
fill it with the query values.

Thanks a lot for your help
Christoph