Update Syntax - suggestion.

Posted in 1995

"tech — Thu, 16 Feb 1995 15:42:25 +0000 — source: Informix-list mailing list archive (1991-1998)

Try this syntax instead: update qprice set qpmat = (select curmat from partmaster where partnum = "PC0651 A") where qpson in ("27", "103") and qpqtyitem = 1 Hope this helps ! Keith. -- *************** tech@compsys.demon.co.uk *************** Tel: 044 (0)1482 803961 Fax: 044 (0)1482 804333 ********************************************************