RE: SQL update make fields match

> You don't have a where clause in you original update 
> statement.  That's what you need to add in order to subset 
> the rows you want to update.

But I do have a where clause.  The original:

UPDATE IMIMSG
  SET IMIMSG.IMACRC = (SELECT DMITMMST.ACREC
                       FROM DMITMMST
                       WHERE DMITMMST.ITNBR = IMIMSG.IMITEM
                       )

Why is that where not a where? <g>  I think I still don't get it.