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 Fri Jun 27 2003 - 17:06:57 CDT