Re: View - Need to return NULL values


"kvrdev1" <kvrdev1@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:F225D772-E43A-4F80-B6AD-720A10BC5A82@xxxxxxxxxxxxxxxx
> I have a view that is joining multiple tables. How do I modify this view
so
> that it also returns when the value is "NULL" for some of the join table
> fields???

Change your INNER JOINs to LEFT JOINs

Stephen Howe


.

Relevant Pages

  • View (SQL Server) Question - Please help!
    ... I have a view that is joining multiple tables. ... How do I modify this view so ... dbo.MEDICATION.MedicationID INNER JOIN ... Prev by Date: ...
    (microsoft.public.dotnet.languages.vb)
  • View - Need to return NULL values
    ... I have a view that is joining multiple tables. ... How do I modify this view so ... dbo.MEDICATION.MedicationID INNER JOIN ... Prev by Date: ...
    (microsoft.public.data.ado)
  • Re: best method to perform operations on word lists
    ... current purpose it'll do the trick but any suggestion for optimization ... my $prev = 'nonesuch584685542256RANOM58544'; ... This didn't modify the list. ... hence my thoughts about language files. ...
    (comp.lang.perl.misc)
  • Re: I just got office 2003, created a document, saved it, now i cant.
    ... >I don't know how to modify my document. ... I need help and i just bought this ... > laptop. ... Prev by Date: ...
    (microsoft.public.word.newusers)
  • RE: Formula counts incorrectly
    ... > I assume that it is only counting 5/5/2005 one time? ... > Could someone please modify this formula to work the way I want it to? ... > was's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=20211 ... Prev by Date: ...
    (microsoft.public.excel.misc)