Re: SQL update statement

Posted in 1994

Cathy Kipp — 15 Dec 1994 17:08:14 -0500 — source: Informix-list mailing list archive (1991-1998)

Dick Hassler writes: -> ->In simplistic terms here is what I want to do: -> update file_a -> set file_a.a2 = "C" -> where file_a.a1 = file_b.a1 Try: update file_a set a2 = "C" where a1 = (select a1 from file_b where file_a.a1 = file_b.a1) Regards, - Cathy -------------------------------------------------------------------------------- Cathy Kipp e-mail: ckipp@vth1.vth.colostate.edu Phone: (303) 491-1294 Colorado State University Veterinary Teaching Hospital Fax: (303) 491-1205