Re: DBACCESS Impossibility?????

> Mark, > You're missing the mark table name in the where. Try something > like this - > > update customer > set number = 100 > where name in > (select mname from mark ) > and cus_no in > (select mcus_no from mark ) ; > > Hope this gets the wheels turning, > Nick > Except that this won't work in a composite situation. Try: update customer set number = 100 where exists (select * from mark where customer.mname = mark.mname and customer.cus_no = mark.cus_no) cheers j. _____________________________________________________________________________ Jack Parker - Hewlett Packard, DMD/IS Boise, Idaho, USA jparker@hpbs3645.boi.hp.com _____________________________________________________________________________ "I'm with the IRS, I'm here to help you" _____________________________________________________________________________ Any opinions expressed herein are my own and not those of my employers. _____________________________________________________________________________