Crystal Reports Totaling with a cuple of 1 to Many relationships

Message

Originally posted by otto

you should do an inner join in order to populate all the records you have.

Are you sure about inner join ?

I swapped my tables around and now the report is running forever. Makes  scene I am no longer linking a 1 to many but a many to many so if I have 200 records in one and 100 n the other I have to pull back 100 record 200 times. OK time to try the Full outer join and put the tables back the way they were 

Again thanks for your help 

See below for what my Documentation tells me on joins

Inner 
An Inner join is the standard type of join. The result set from an Inner join 
includes all the records in which the linked field value in both tables is an 
exact match.

Left outer 
The result set from a Left Outer join includes all the records in which the 
linked field value in both tables is an exact match. It also includes a row for 
every record in the primary (left) table for which the linked field value has no 
match in the lookup table

Right Outer 
The result set from a Right Outer join includes all the records in which the 
linked field value in both tables is an exact match. It also includes a row for 
every record in the lookup (right) table for which the linked field value has no 
match in the primary table

Full Outer 
A Full Outer join is a bidirectional outer join where you can see all records in 
your linked tables. The result set from a Full Outer join includes all the 
records in which the linked field value in both tables is an exact match. It 
also includes a row for every record in the primary (left) table for which the 
linked field value has no match in the lookup table, and a row for every record 
in the lookup (right) table for which the linked field value has no match in the 
primary table