RE: Update and Join

From: Sinardy Xing <SinardyXing_at_bkgcomsvc.com>
Date: Mon, 30 Jun 2003 01:01:48 -0700
Message-ID: <F001.005BBF4E.20030630002924@fatcity.com>

Hi Castro,

Can you set your font size
bigger? You are not lawyer right?

may be this can help
you....

UPDATE table SET column =
something_new
<FONT
size=3>WHERE primary_key_or_just_key in (select foreign_or_primary_key as usual)
AND other_key in
(other select foreign_or_primary_key
as usual);

Sinardy

  -----Original
  Message-----From: Teresita Castro
  [mailto:[EMAIL PROTECTED]Sent: 28 June 2003   06:44To: Multiple recipients of list ORACLE-LSubject:   Update and Join

  I am trying to make and update that have a Join.

  UPDATE ITEMLOC       INNER JOIN
  ITEMMAST ON ITEMLOC.ITEM = ITEMMAST.ITEM
  SET ITEMLOC.PREFER_BIN='PATEN-A'

  WHERE     (ITEMMAST.INVEN_MAJCL = 'A' AND   ITEMLOC.PREFER_BIN='FICTICI')

  But I don't have the right sintaxis, did some one knows how to do this or   if is posible do a join in a update statement?   Thanks!!! Received on Mon Jun 30 2003 - 03:01:48 CDT