From Teresita.Castro@s-martmx.com Fri, 27 Jun 2003 15:06:57 -0700 From: "Teresita Castro" Date: Fri, 27 Jun 2003 15:06:57 -0700 Subject: Update and Join Message-ID: MIME-Version: 1.0 Content-Type: text/plain 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!!!