Hi guys,
I have a question about an SQL statement that I have to do. The complexity is big (lots of tables), but the problem can be resumed to this. Imagine I have the following query:
SELECT t.x
FROM the_table t
WHERE t.y = 'a'
MINUS
SELECT t.x
FROM the_table t
WHERE t.y = 'b'
In my original statement, I don't have only one table but many. But the issue is the same. I select a set of data and I minus the same statement with another criteria. I tried with some OR combination but never had the same result...
Does anyone have an idea?
Thanks,