>Hi,
>
>Has anyone tested to see if using the join clause is quicker than using an equivalent expression in the where clause. If so, is it significantly faster.
>
>Thanks
>
>Mace.

OK, I've tested it...

Generally the join is 2% quicker