View Single Post
  #7 (permalink)  
Old October 25th, 2004, 09:08 AM
happygv happygv is offline
Friend of Wrox
 
Join Date: Jun 2003
Location: Bangalore, KA, India.
Posts: 2,480
Thanks: 0
Thanked 1 Time in 1 Post
Default

Hi Dave,

Not sure on what order you are expecting this to be.
Code:
(Select table_a_id, table_a_title, table_b_datetime as DateCol
from TABLE_A a, TABLE_B b where a.table_a_id = b.table_a_id order by DateCol)
UNION
(Select table_a_id, table_a_title, table_c_datetime
from TABLE_A a, TABLE_C c where a.table_a_id = c.table_a_id order by DateCol)
UNION
(Select table_a_id, table_a_title, table_d_datetime
from TABLE_A a, TABLE_D d where a.table_a_id = d.table_a_id order by DateCol)
Order by DateCol
Use the last order by in BLUE if required.

Hope this is what you are looking for.
Cheers!

_________________________
- Vijay G
Strive for Perfection