Re: Syntax error trying to formulate a sub-query

Posted in 1999

Chuck Renaud — Wed, 17 Mar 1999 12:55:33 -0600 — source: Informix-list mailing list archive (1991-1998)

> SELECT tabname > FROM systables > WHERE tabid NOT IN ( > SELECT viotid FROM sysviolations > UNION > SELECT diatid FROM sysviolations > );> > And I get a -201, syntax, error pointing to the UNION keyword. This is supposedly not supported in IDS--only XPS. There's a bug 89474 about this, and another 92332 that's XPS- specific.

Related threads

Force Assert Fail
IDS Function problem