4
Hello,
I have a very simple table as an example:
I also have a query that checks the existing values within the IN, example:
SELECT * FROM tLetras l WHERE l.letras IN ('A','B','C','D','E','F','G','H','I','J','K','L','M','N','O','P','Q','R','S','T','U','V','W','X','Y','Z');
This query will certainly return me all the values that are in the table tLetras
.
What I really need is to know which letters (values) who are inside the IN
and that are not within the TABLE
. I mean, the values I need to know are 'E','H','I','L','O','P','Q','R','S','T','U','V','W','X','Y','Z'
, which are precisely the values that are not in the TABLE
but who are in the IN
.
Try using the MINUS operator, it’s EXCEPT on Oracle.
– anonimo