RE: Update and Join

[Sinardy Xing]

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 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:44 To: Multiple recipients of list ORACLE-L Subject: 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!!!