RE: query using OR operator

From: Suhen Pather <Suhen.Pather_at_strandbags.com.au>
Date: Wed, 06 Jun 2001 00:01:00 -0700
Message-ID: <F001.0031D700.20010605235532@fatcity.com>

Greg,

Correct me if I am wrong but both will return duplicates since the OR operator is used.

The primary key is on PRD_LVL_CHILD.PRDMSTEE.

Regards
Suhen

Hi Suhen,

The UNION ALL will return duplicates from the two queries, whereas the original query will not, right? So the query is tuned, but it returns a different result set.

Do you agree?

Best regards,
- Greg

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Greg Moore
  INET: sqlgreg_at_pacbell.net

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: ListGuru_at_fatcity.com (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: Suhen Pather
  INET: Suhen.Pather_at_strandbags.com.au

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: ListGuru_at_fatcity.com (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). Received on Wed Jun 06 2001 - 02:01:00 CDT