Unanswered: What is equivalent of MINUS of Oracle in DB2?
I 'm working on DB2 8.1.2. I have a query which was working fine in Oracle. The query is following
select user_id,login_id from users
where user_id in
(SELECT DISTINCT Y.SUPERVISOR_ID FROM REPORTS_TO X, REPORTS_TO Y WHERE X.USER_ID=Y.SUPERVISOR_ID
SELECT X.SUPERVISOR_ID FROM REPORTS_TO X WHERE X.SUPERVISOR_ID=USER_ID)
and upper(region_code) = upper(?)
Now in DB2 the "MINUS" function is not accepted. So how can I rewrite this query to make it work in DB2.
I will appreciate your help in this.