Update and Join

[Teresita Castro]

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!!!