And yea, I got the syntax wrong ;o)) Don't point it out to me....the bad day
continues...
-----Original Message-----
Sent: 05 December 2001 11:25
To: '[EMAIL PROTECTED]'
Importance: High
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: [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: Thomas, Kevin
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).
