title: When field "IS NULL" join on an alternative field - Access 2007
body: <p>So the short end of it is this is what I want to do, but I don't know the proper syntax.</p>
  
  <p>Table 1, Table 2
  Name, SSN, DOB, List, Date</p>
  
  <p>I want to do a left join using the SSN, but when the SSN field IS NULL I want it to join on the DOB field Where the Name matches.</p>
  
  <p>I can't join on name due to the file being 19k records and most of them are common names.</p>