In general, which would be faster, a conditional join, or a regular join with a WHERE statement in the TABLE request?

Thank you,

John

This message has been edited. Last edited by: Kerry,

A conditional join is faster because only records meeting the where criteria are joined, but with a regular join all records are joined and then the where criteria is considered to remove the records not meeting the where criteria. Look at page 15-32 -34 in Creating Reports (7.1.3) for a better understanding of conditional joins -- one thing is all fields used in the where statements must be in a single path.