thank you ALL so VERY VERY VERY VERY much!!! I tried several things that I thought were not working, but it was because I was mis-interpreting my update count, so I think all of the solutions would have worked. Here's the final update statement that I used You are all awesome. I can't thank you enough!! Barb update workorder_fact a set status = (select status from workorder_fact@repdb b where a.job_nbr=b.job_nbr and a.adj_nbr_key=b.adj_nbr_key and a.issue = b.issue) where a.status='D' and a.issue='01-APR-08' AND EXISTS (select null from ad_mart.workorder_fact@repdb b where b.job_nbr = a.job_nbr and b.adj_nbr_key = a.adj_nbr_key and b.issue = a.issue ) > > On Fri, Apr 16, 2010 at 2:25 PM, Jacques Kilchoer < > Jacques.Kilchoer@xxxxxxxxx> wrote: > >> You might want to add to you where clause >> >> >> >> AND EXISTS >> >> (select null from ad_mart.wof@repdb b where b.job_nbr = a.job_nbr and >> b.adj_nbr_key = a.adj_nbr_key) >> >> >> >> because without the AND EXISTS clause you will be updating rows in A that >> have no corresponding vlaue in B. >> >> >> >>