Re: DBACCESS Impossibility?????

Posted in 1995

"Andy Kent" — Tue, 26 Dec 1995 19:08:40 GMT — source: Informix-list mailing list archive (1991-1998)

> > 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. ... and simple inner joins would be more efficient than those subqueries if you have the necessary indexes in place. akent@cix.compulink.co.uk (Andy Kent) ------------------------------------------------ Freelance Informix Database Specialist, Redland, Bristol, England