when i try to use order by in:
CREATE MULTISET VOLATILE TABLE tt_PopToInclude,NO LOG AS
TeraData Executed as Single statement. Failed [3706 : 42000] Syntax error: ORDER BY is not allowed in subqueries.
how can i fix it?
Well, you got the same answer already twice yesterday:
there's no order in a table, thus applying an ORDER BY within a INSERT is useless (=not allowed).
Why do you think you need it?