Hi Josh ----

I could be wrong, but if you just do:

SELECT * FROM table1 UNION SELECT * FROM table2 UNION SELECT * FROM table3

With no ORDER clause, isn't the order pretty much automatically 1,2,3 in the results set?




>
>If you just want all the table 1 records, then table 2, then table 3 and don't care what order they're in within each table, you can do this:
>

>SELECT '1',* FROM table1 ;
>UNION ;
>SELECT '2',* FROM table2 ;
>UNION ;
>SELECT '3', * FROM table3 ;
>   ORDER BY 1

You can also make this work if you have other columns that you can use to sort the data within each table.
>
>>I'd like to combine 3 tables using UNION. But I dont need any order, I'd like to keep records in order they come from tables:
>>table1, table2, table3.
>>Is it possible?
>>Thanks Mark