Re: Subquery

From: <dgoulet_at_vicr.com>
Date: Tue, 29 May 2001 05:26:20 -0700
Message-ID: <F001.00311A9F.20010529051151@fatcity.com>

 Why would you want to use a subquery? I can see no reason or it and they do tend to slow things down.

Dick Goulet

---------------------- Reply Separator ----------------------

Author: Roland.Skoldblom_at_ica.se
Date: 5/29/01 4:15 AM

Hallo you DBAs

How can I write this sql query using subqueries?

SELECT pbk.nielsenart.varunamn, pbk.nielsenart.strl, pbk.nielsenart.varutxt,
null, pbk.nielsenart.vgrp, rik2.hierarki_tekst.tekst, null, pbk.sortiment_vgrp.sortiment, pbk.nielsenart.art_grp, pbk.nielsenart.art_ugrp,
null
FROM pbk.nielsenart,pbk.sortiment_vgrp,rik2.hierarki_tekst, pbk.rapporttmp
WHERE pbk.nielsenart.vgrp=rik2.hierarki_tekst.vgrp

AND pbk.sortiment_vgrp.vgrp=pbk.nielsenart.vgrp
AND rik2.hierarki_tekst.sett_id=2
AND rik2.hierarki_tekst.landkode=46

AND pbk.nielsenart.ean=pbk.rapporttmp.EAN AND ROWNUM=1 Roland Sköldblom

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: Roland.Skoldblom_at_ica.se

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:
  INET: dgoulet_at_vicr.com

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 Tue May 29 2001 - 07:26:20 CDT