Updating

> > I need to update one table based on data in a second. TFM doesn't have > example exactly that I need. I have tried arranging the syntax in a > couple of differnt ways, with no luck. I am new to informix but have a > tight deadline. here it is You're close, this should work: update award set award.AWARD_AMOUNT = award.AWARD_AMOUNT + award.CARRY_FORWARD where AWARD_ACCOUNT IN (SELECT MOD_ACCOUNT FROM mod where mod.MOD_PROCESSING = "2X" or mod.MOD_PROCESSING = "CL");cheers j. _____________________________________________________________________________ Jack Parker | Hewlett Packard, BSMC Boise, Idaho, USA| No soap - radio! jparker@hpbs3645.boi.hp.com | _____________________________________________________________________________ Any opinions expressed herein are my own and not those of my employers. _____________________________________________________________________________