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

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

Thanks so For
-baba




> hrishy@xxxxxxxxx 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

.

Relevant Pages

  • Re: SQL: getting data for a null value column ??
    ... > so i have to take name from tabB only. ... > o/p what i want is (without using union) ... > FROM taba a,tabb b where b.bbankcode=a.bankcode ... The UNION construct in it's basic form will select *all* ...
    (comp.databases.oracle.server)
  • Re: View of two tables with same data
    ... Select * from taba ... union all ... select * from tabb ... Dave Ballantyne ...
    (microsoft.public.sqlserver.programming)
  • Re: Query Join no unique link
    ... NrSeq seems to be different but if you do not care about that then one ... Or you can just disregard the TabB. ... (yes the join fields are the same, but I don't have a unique link between ...
    (microsoft.public.sqlserver.programming)
  • Update TabA with value fromTabB
    ... TabA is a Detail Table, Col A belong to TabA ... TabB is a Header Table, ...
    (microsoft.public.sqlserver.programming)
  • Variables Update einer Tabelle
    ... ich habe schwierigkeiten eine Update-Klausel zu formulieren. ... Tabellen (TabA, TabB). ... Ich formuliers mal in Worten: ...
    (microsoft.public.de.german.entwickler.dotnet.datenbank)