Linking tables in Crystal 2011

[jchewsmith]

If I am linking multiple tables and there is one table that has all of the lines that I want and one of the tables only has some, but I want the info from the ones that do match. I have tried the left outer, i have tried the >= but not getting the info from the second table?

table 1
1 50
2 75
3 25
4 30
5 20
table 2
1 6
3 8
5 7

results
1 50 6
2 75 -
3 25 8
4 30 -
5 20 7

 

[kray4660]

What are you expecting. It appears the left outer join is giving you all the data (that there is) on the second table. If you only want the non-null data from the second table, then do an inner join.