Re: SQL: getting data for a null value column ??

From: Anurag Varma <avdbi_at_hotmail.com>
Date: Thu, 04 Aug 2005 01:21:30 GMT
Message-ID: <u4eIe.800$rI6.267@twister.nyroc.rr.com>

hrishy_at_gmail.com wrote:
> Hi
>
> SQL> l
> 1 select a.bankcode,a.bankname
> 2 from taba a ,tabb b
> 3* where a.bankcode=b.bbankcode(+)
> SQL> /
>
> BANKCODE BANKNAME
> ---------- ---------------
> 001 firstbank
> 002 secondbank
> 003 thirdbank
> 004 fourthbank
> 004 Firstunionbank
>
> regards
> Hrishy
> baka wrote:
>

>>Thank you for replying to my questions so far. and for this also
>>First it not an home work(Just curios),
>>and what i have given is an image .
>>there several table are also linked , so i avoided using
>>union
>>any more ideas?
>>
>>PS:
>>004                  Firstunionbank  should be read as
>>005                   Firstunionbank

>
>

???
Why not just:

select * from taba;

Anurag Received on Wed Aug 03 2005 - 20:21:30 CDT