Left Outer Join not giving results needed

[modglin]

Using Crystal 8.5. I have two tables that I am linking together by Employee # and Company Name.
Table1 has ALL employee information
Table2 has classes taken.
I have used a left out join from Table1 to Table2. My understanding is that when I use that type of join, I will get all records from Table1 and only the records that match from Table2.
Not so in this case. If I pull in all the information from Table1, I have 1,929 records. As soon as I pull in a field from the Table2 - it drops to 567 records.
I have tried reversing the link, equal join (which I knew would not give me the info), right outer and etc and the fields from the first table do not show back up.
The link is through ADA - which is from a FoxPro database.

 

[nagornyi]

Try putting outer join on both links.

 

[Stoffel24]

I have a feeling that should you put in any criteria on the right hand table in a left out join (eg Table1 left outer join Table2 and then in eg your records selection criteria specify that table2.name like "*THIS*&quot you can have a problem. I don't know whether this is a bug or if I was just not understanding what was happening. Also this was in version 9.

An option you might be able to implement is to use a view and combine the data required in the appropriate fashion in your view. Then simply report off the view.