Posting from the Informix-list

--- "Astemborski, Jon" <JAstemborski@biztravel.com> > wrote: >Hello everyone, > >I am trying to update a table based on the contents of another table but >only where the primary keys are equal. Because I can not directly reference >the non updated table in a from statement it throws off what I want to do. >I tried to replicate it with a sub queries but I received error 284 (a query >has not returned not exactly one row). I understand the error, but how can >I perform a multirow update based on the contents of another table? instead of WHERE yadayada = (select ..... WHERE yadayada IN (select ..... == Maintainer of the procrastinator's FAQ. Well, maybe tomorrow I will be. _____________________________________________________________ Want a new web-based email account ? ---> http://www.firstlinux.net