Subquery

From: <Roland.Skoldblom_at_ica.se>
Date: Tue, 29 May 2001 04:21:25 -0700
Message-ID: <F001.003119A6.20010529041545@fatcity.com>

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). Received on Tue May 29 2001 - 06:21:25 CDT