Dear Shadab Mehboob

I have to clarify more before itself now the

In yyy_tab or zzz_tab common ID or may not Common in this case the row
should select either one of table having data instead of both table having

Suppose
Xxx id 20/06/07 -- yyy_tab
Xxx id 30/06/07 -- zzz_tab
Xx id 01/07/07 -- yyy_tab

Then required out put is

Name id start_date end_date
Xxx id 20/06/07 30/06/07
Xx id 01/07/07 baanck

Can make understood..? Pl




-----Original Message-----
From: Shadab Mehboob [mailto:[Email address protected]
Sent: Monday, July 02, 2007 11:19 AM
To: [Email address protected]
Subject: Re: any body help pl. output in single line

**A LazyDBA.com subscriber has responded to your lazydba.com post**
**LazyDBA.com mail shield has forwarded you this email,
**and removed any attachments, and kept your email address secret
**from this person, and any viruses/trojans.
**If you reply to this email, the person will see your email address as
normal
**Anything below this line is the original email text


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 " [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