Home Forums SQL Server 2008 T-SQL (SS2K8) Table Join using unique values or where Null = all values RE: Table Join using unique values or where Null = all values

  • March 20, 2013 at 7:47 am

    #1598902

    Something like this ?

    SELECT b.DeliveryName, a.Item, a.[Description]

    FROM

    TableA a JOIN Tableb b ON (a.Area = b.ColId) or (a.Area is null)

    There is always something new to learn.
    My personal SQL Blog[/url]