I think his query will do:

select A.id,A.name,to_char(A.dt,'DD/MM/YY') || to_char(B.dt,'DD/MM/YY')
from yyy_tab A, zzz_tab B
where A.id=B.id;

if it works for you, please use it as a basement for a more elaborate
query because I feel it's a little simplistic.

Israel the "DBA".

Mohan Rao escribió:

>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
>
>
>
>
>
>
>
>---------------------------------------------------------------------
>TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
>To post a dba job: http://jobs.lazydba.com
>To Subscribe : http://www.LazyDBA.com
>To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>
>
>
>
>

Oracle LazyDBA home page