Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Octav Chiriac — — source: Informix-list mailing list archive (1991-1998)
Zep.
update tableB set
(tableB.filedA) = ((SELECT tableA.fieldA
FROM tableA
WHRE tableA.fieldB = tableB.fieldB))
WHERE
tableB.fieldB IN (SELECT fieldB
FROM tableA)
I didn't test it but it should work.
Hope it helps,
Octav
On Thu, Sep 16, 1999 at 09:25:57AM -0500, Justin Tsui wrote:
> Is there a way to do this???
>
> update tableB set tableB.fieldA = tableA.fieldA where tableA.fieldB => tableB.fieldB
>
--
Octav Chiriac Phone: (373) 2 22 99 67
NetInfo S.R.L. Fax: (373) 2 21 36 59
Chisinau (373) 2 22 84 88
Moldova, Republic of mailto:com@netinfo-moldova.com
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.