RE: Update Statement

Posted in 2001

Jay Roberts — Thu, 15 Feb 2001 13:04:14 -0800 — source: Informix-list mailing list archive (1991-1998)

Have you tried this? update admin.subc set admin.subc.deal_key = "NVD" where admin.subc.chas_key = (select chas from dblog1.eire) -----Original Message----- From: Kirk Davis [mailto:kirk.davis@volvo.com] Sent: Thursday, February 15, 2001 8:39 AM To: informix-list@iiug.org Subject: Update Statement Hi All, Hope someone out there can help me with this one, it's driving me mad! Does anyone have any idea, why the statement below would not work, I just get the error " 522: Table (dblog1.eire) not selected in query." I've tried also making the first line UPDATE admin.subc, dblog1.eire but but still no luck, I've read through the Informix SQL guide, but It doesn't give me an clues?? UPDATE admin.subc SET admin.subc.deal_key = "NVD" WHERE dblog1.eire.chas = admin.subc.CHAS_KEY; Any help greatly appreciated! Best Regards to all, Kirk