Steve,

Basically, it doesn't matter whether you use the JOIN..ON statement for Joins, or if you join the tables in the WHERE clause
The first one is ANSI/ISO SQL-92 compliant, and the second is legacy family of constructing join and it is more succinct.

Anyway you have to be careful about the ordering of the clauses in a OUTER join. The order in which tables are joined directly affects which rows are included in the result set and which value they have. ( the ordering of the clauses in an INNER joins doesn't affect the result set )

I am always using the ANSI approach ( INNER/OUTER JOIN ... ON...)

Cheers,

Zoran


>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 ...]