>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
You can make it sure by adding one new field:
Select 1 as listorder, * From table1 ;
Order by 1 ;
Union All Select 2 as listorder, * From table2 ;
Union All Select 3 as listorder, * From table3 ;
Edward Pikman
Independent Consultant