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

• tim8w

  Old Hand

  Points: 375

  More actions

  March 30, 2022 at 5:14 pm

  Go to Answer

  #4008349

  Hi,

  My Main Table looks like this:

  

  My Lookup Tables look like this:

  

  I want to do a SELECT such that the resulting Table looks like this:

  

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

  • This topic was modified 2 years, 7 months ago by  tim8w. Reason: typo

• ratbak

  Ten Centuries

  Points: 1358

  More actions

  March 30, 2022 at 6:57 pm

  Answer

  #4008419

  Use LEFT OUTER JOIN to the lookup tables.