title: I am trying to join tables where a user record does not exist in one of the tables
body: <p>I have a rewards program with a grants and a purchases table. I am attempting to create a report that displays a users balance. If the user has not made a purchase, however, the balance report does not contain their record. The report only contains users who have earned grants AND made at least one purchase.</p>
  
  <p>The third table being used is our user records table to pull in the user record.</p>
  
  <p>Is there a way to treat no record in the purchases table as a '0' balance?</p>