Steve,

You can have up to 9 JOIN's per SELECT and each JOIN can have multiple Join Conditions.

>I have multiple join conditions, 4. How would I set those up?
>
>From looking at the syntax in the help, it looks like you can use only one join condition with the "ON" and you can use multiples with the "WHERE"
>
>Should I split them up, 1 & 3. Or put all 4 on the "WHERE", or does it matter at all?
>

[ON JoinCondition...]

>
>

[WHERE JoinCondition [AND JoinCondition ...]