Use this
select a.id,a.name,a.dt,b.dt from yyy_tab a,zzz_tab b
where a.id=b.id


Regards
Shadab
----- Original Message -----
From: "Mohan Rao " <oracledba-ezmlmshield-x68152671.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Sent: Sunday, July 02, 2006 10:23 AM
Subject: any body help pl. output in single line


> 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