Home Forums SQL Server 7,2000 SQL Server Newbies view syntax RE: view syntax

  • February 7, 2005 at 7:42 am

    #540929

    You can also do it this way...

    FROM        

     dbo.OccMain ocm

     INNER JOIN dbo.OccMalignant omg ON( ocm.AilmentID = omg.AilmentID)

     LEFT JOIN dbo.CodeLookUp c ON( c.Code=omg.SentNode AND c.CType = 65)

    I wasn't born stupid - I had to study.