"TW" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > I have been doing a Union query and would like to obtain distinct > results. > Via the manual, the correct way to accomplish this is to do a UNION > statement (versus > doing a UNION ALL). > > Problem: I want the order of the select statements left intact after > the UNION > select statements.
Order is never guaranteed in a SQL statement's resultset, unless this statement specifies an ORDER BY clause. If some statement without such a clause happens to give you an order you want, it does so by accident. If you want a particular order, say so in the statement. > How should I write this thing so that I get the ascending > height ALONG WITH the alternating sides according to the order of the > select statements that I put in the query? It would help if you showed the actual statement you have now, and the results you expect. Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
