RE: Update query

From: Thomas, Kevin <Kevin.Thomas_at_calanais.com>
Date: Wed, 05 Dec 2001 03:33:13 -0800
Message-ID: <F001.003D59D1.20011205032554@fatcity.com>

SELECT a.sql_basics

      ,b.chapter3
  FROM bookshelf

      ,b.book
 WHERE b.chapter3 = 'basic sql constructs'
   AND a.sql_basics = 'book that should be read before posting requests like

this';

;o)

-----Original Message-----
Sent: 05 December 2001 09:55
To: Multiple recipients of list ORACLE-L

Hallo,

How can I update the field PRICE in table B with prices from field NEW_PRICE in table A. with condition LANGUAGE_CODE IS = 412 (that condition should be taken from table B)
Please give me an example of a sql statementö.

Thanks in advance

Roland

-- 
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: Thomas, Kevin
  INET: Kevin.Thomas_at_calanais.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 Wed Dec 05 2001 - 05:33:13 CST