Use outer join

a.id(+)=b.id
----- Original Message -----
From: "Mohan Rao" <[Email address protected]
To: "'LazyDBA Discussion'" <[Email address protected]
Cc: "'Shadab Mehboob '" <[Email address protected]
Sent: Monday, July 02, 2007 11:31 AM
Subject: RE: any body help pl. output in single line


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