Hi Steve,
Check this out.
SELECT ;
FROM ;
trial!t1 ;
FULL JOIN trial!t2 ;
ON T1.code = T2.t1code ;
FULL JOIN trial!t3 ;
ON T2.t1code = T3.t2code ;
FULL JOIN trial!t4 ;
ON T3.t2code = T4.t3code
Aashish
>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 ...]