Re: View creation Help NEEDED!!!

From: AshVsAOD (.)
Date: 03/17/04 

Date: Wed, 17 Mar 2004 15:25:06 +1100

Thank you very much. Knew it would be easy. I really do appreciate it Ray.

Clint
"Ray Higdon" <sqlhigdon@nospam.yahoo.com> wrote in message
news:uxQTzW9CEHA.2920@TK2MSFTNGP09.phx.gbl...
> Use isnull, see BOL for details
>
> --
> Ray Higdon MCSE, MCDBA, CCNA
> ---
> "AshVsAOD" <.> wrote in message
> news:OOY7AM9CEHA.3344@tk2msftngp13.phx.gbl...
> > Newbie question no doubt...
> >
> > I have three tables with a Column called Fee...
> >
> > I need to create one view from these columns that total the fee column.
> >
> > However in each of the three tables a client could have a entry..
> > e.g
> > Table One
> > abcd102 Fee=100
> > gdgd400 Fee=50
> >
> > Table Two
> > abcd102 Fee=75
> >
> > Table Three
> > gadg890 Fee=10
> >
> > Now when I combine these three tables I end up getting <NULL> appearing
in
> > one of the columns due to there not being an entry in that column.
> >
> > e.g 2 (Output)
> >
> > abcd102 100 75
Null
> > gdgd400 50 Null
Null
> > gadg890 Null Null 10
> >
> > Can anyone assist in the code that will set the NULL to a 0 (zero)
inside
> > the view? Or is there another way that does NOT involve table
> > modifications?
> >
> > Kind Regards,
> >
> > Clint
> >
> >
>
>