I have a recordset that i open with 3 SELECT statements joined by the UNION keyword. Is there a way to order rows returned by these multiple queries? ORDER BY seems to order each SELECT query individualy but i'd like to order all the rows returned by all the queries. So that my recordset would be sorted entirely and not by sections (each SELECT .. ORDER BY creates a section of sorted rows). This is what my query looks like :<BR> SELECT name FROM whatever ORDER BY name<BR> UNION<BR> SELECT name FROM anotherTable ORDER BY name<BR> UNION <BR> SELECT name FROM lastTable ORDER BY name;<BR><BR> thanks . Etienne.