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: [EMAIL PROTECTED]
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: [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:
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).
