SQLTeam.com | Weblogs | Forums

SELECT when main table contains NULL and you are attempting a JOIN

Hi,

My Main Table, Lookups and final results look like this:

So basically I want to maintain the NULLs after the SELECT.

You can use LEFT OUTER JOIN to keep the null.