View - Need to return NULL values

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

Any help would be greatly appreciated!!!
Thank you,
-Valerie

SELECT TOP 100 PERCENT dbo.PATIENTMEDICATION.PatientMedicationID,
dbo.MEDICATION.MedicationDS, dbo.MEDICATION.MedicationID,
dbo.DOSAGEUNIT.DosageUnitDS,
dbo.PATIENTMEDICATION.DosageUnitID, dbo.PATIENTMEDICATION.Dosage,
dbo.DURATIONUNIT.DurationUnitDS,
dbo.PATIENTMEDICATION.DurationUnitID,
dbo.PATIENTMEDICATION.Duration, dbo.PATIENTMEDICATION.BegunDT,
dbo.PATIENTMEDICATION.DiscontinuedDT,
dbo.PATIENTMEDICATION.ActiveYN, dbo.PATIENTMEDICATION.VisitID,
dbo.PATIENTMEDICATION.PatientID
FROM dbo.PATIENTMEDICATION INNER JOIN
dbo.MEDICATION ON dbo.PATIENTMEDICATION.MedicationID =
dbo.MEDICATION.MedicationID INNER JOIN
dbo.DOSAGEUNIT ON dbo.PATIENTMEDICATION.DosageUnitID =
dbo.DOSAGEUNIT.DosageUnitID INNER JOIN
dbo.DURATIONUNIT ON
dbo.PATIENTMEDICATION.DurationUnitID = dbo.DURATIONUNIT.DurationUnitID
ORDER BY dbo.PATIENTMEDICATION.VisitID, dbo.PATIENTMEDICATION.ActiveYN DESC,
dbo.PATIENTMEDICATION.PatientMedicationID


.

Relevant Pages

  • Re: Monday --> Sunday
    ... FROM tblJobSite INNER JOIN (tblEmployee INNER JOIN tblTimeEntry ON ... This is designed to calculate overtime. ... I know the "-Weekday" command by default begins Monday. ... way to modify this or is there another 'function' that begins on ...
    (comp.databases.ms-access)
  • 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)
  • Re: Inner Join Question
    ... You'll need to change the INNER JOIN to a LEFT JOIN. ... instead of all records despite the presence of linked data in the "Calls" ... Any idea on how to modify the following query so everything will show up? ...
    (microsoft.public.access.queries)
  • Re: View - Need to return NULL values
    ... > I have a view that is joining multiple tables. ... How do I modify this view ... Stephen Howe ... Prev by Date: ...
    (microsoft.public.data.ado)
  • Re: Simple Query Not Producing Certain Records...
    ... John Spencer wrote: ... > Or change the INNER JOIN to a RIGHT JOIN - which should give you all matches ... looking at the SQL - i'm not sure why it ... Prev by Date: ...
    (microsoft.public.access.queries)