The SQL operators SUBSET and INTERSECT were added in
version 7, for set-like queries on strlst values. SUBSET
is true if and only if all left-side value(s) are present on the
right side; INTERSECT is true if any left-side values are
present on the right.
INTERSECT are new keywords in Texis version
7. If either is already in use (in all-upper or all-lower case) as an
identifier - table name, column name, index name, etc. - then its
usage must be enclosed in double-quotes in SQL in version 7, to
prevent syntax errors. E.g.: SELECT "subset" FROM MyTable ...
Copyright © Thunderstone Software Last updated: Aug 4 2020