how to creat temp table when using union based on query from three table ?

[eluser]ram reddy[/eluser]
Hi,


I have one problem in union query . I am using union to get records from three different tables . It is working fine , but if i use order by Date, it does not show correctly . Some one said to create temp table when you call union , i don't know how to create temp table using union .

Please help me to fix the problem.

Thanks!