The MINUS operation is prety straight forward.
The result set from query 1 is compared to the result set of query 2 and any
records that exist in both are removed.
With this in mind, if your first query and your second query result sets
have NO RECORDS IN COMMON then you will ONLY get the records from your first
queries result set.
Kevin
-----Original Message-----
Sent: Thursday, July 12, 2001 5:47 PM
To: Multiple recipients of list ORACLE-L
I am writing a SQL query using the MINUS operator.Both the select statements
return a number result and I
am trying to get the o/p with the difference of both the queries using the
MINUS
between the two select statements.But I am getting the o/p of the first
query only
and the displayed result is not the subtracted value.Both select statements
give
different number o/p when run individually.What could be wrong.
Is there anything that i am missing to consider when using the MINUS
operator.
Pls help
Thanks
Ravindra
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ravindra Basavaraja
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Kevin Lange
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
