Re: SQL: getting data for a null value column ??
- From: "Chris ( Val )" <chrisval@xxxxxxxxxxxxxx>
- Date: 3 Aug 2005 20:24:23 -0700
baka wrote:
> Thanks hrishy san (&)
> you are right in one way, but, i mentioned tabB is a master table
> so i have to take name from tabB only. if it not exists then,i have to
> take it from transaction table i.e tabB.
>
> o/p what i want is (without using union)
>
> 001 tabBbankname
> 002 secondbank
> 003 tabBthirdbank
> 004 fourthbank
> 005 Firstunionbank
>
> PS: about union
>
> SELECT a.bankcode,a.bankname
> FROM
> taba a,tabb b where a.bankcode=b.bbankcode(+)
> union
> SELECT b.bbankcode,b.bbankname
> FROM taba a,tabb b where b.bbankcode(+)=a.bankcode
>
> Thans Mr.Arun for reading my mail. but what..
[snip]
Please do not top post, thanks.
Given what you have written, I suspect you do not
understand what the UNION construct does.
Like 'Anurag' said, what's wrong with:
select * from taba;
etc...
?
The UNION construct in it's basic form will select *all*
distinct values.
Cheers,
Chris Val
.
- References:
- SQL: getting data for a null value column ??
- From: baka
- Re: SQL: getting data for a null value column ??
- From: Chris ( Val )
- Re: SQL: getting data for a null value column ??
- From: baka
- Re: SQL: getting data for a null value column ??
- From: hrishy
- Re: SQL: getting data for a null value column ??
- From: Anurag Varma
- Re: SQL: getting data for a null value column ??
- From: baka
- SQL: getting data for a null value column ??
- Prev by Date: Re: SQL: getting data for a null value column ??
- Next by Date: Re: AIX or W2k3 to run Cluster?
- Previous by thread: Re: SQL: getting data for a null value column ??
- Next by thread: Re: SQL: getting data for a null value column ??
- Index(es):
Relevant Pages
|
Loading
