Our ERP system runs on M$ SQL.  I try not to meddle with it because any changes are ruined when we upgrade to the latest version of the software. So, I created another small database on the same server with the additional information needed for my reports. 

 
Table 1 is the list of our outside sales reps and their e-mail addresses.

The 2nd set of tables are sales tables from our ERP database. 

Here is my problem.  I am writing a weekly sales report and using an outside program to automate things, I am e-mailing them to our sales reps.  However, if a rep doesn't have any sales, then nothing comes up in crystal when that rep number is entered as a parameter.  Knowing that I wanted a report of some kind to result, I tried to do a left outer join from the rep number field in table 1 (from my database) to the second set of tables I get no records.  If I get no records, then I cannot pull the e-mail address from my table to e-mail a blank report. 

 
I upgraded to XI Developer because I had read on the web that CR9 had problems with outer joins. 

 
What am I doing wrong?