[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

Oracle has MINUS, What about DB2?

In Oracle we can do:
BEGIN-SELECT
A.FLD1
A.FLD2
FROM TBL1 A
MINUS
SELECT B.FLD1,
       B.FLD2
FROM TBL2 B
END-SELECT

In DB2, it will have an error.
I know I can get a way around with it.  But I would like to know if there is
anythig equivalent to MINUS?

Thanks.
Chi