SQLTeam.com | Weblogs | Forums

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

Transact-SQL
#1

Hi,

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

Combined
Combined934×580 10.9 KB

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

#2

You can use LEFT OUTER JOIN to keep the null.