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

From: <hrishy_at_gmail.com>
Date: 3 Aug 2005 05:18:42 -0700
Message-ID: <1123071522.332991.32390@f14g2000cwb.googlegroups.com>

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
Received on Wed Aug 03 2005 - 07:18:42 CDT