1. Change the Join Type to "Unmatched Records".
   
   
   
   
2. Click the OK button.
3. Run the query again.
   
   
   
   
4. Close the query and result windows.
   
   
   
   Do not disconnect from this host.