HI Experts



My query is below



Select id,name,dt from yyy_tab

union all

select id,name,dt from zzz_tab



output is coming like this

--------------------

Xxx pumps 28/06/07

Xxx pumps 30/06/07



But out put required is in this format any body help pl.



Xxx pumps 28/06/07 30/06/07



Pl help






Oracle LazyDBA home page