Just my $0.02:

JOINs are more clear than WHEREs.
The speed difference is not important.
Oracle doesn't know about JOINs, only WHEREs. So, if you think you might need to have an Oracle backend, use WHEREs from the beginning.

Vlad

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