I think it's easier to get that coding wrong using a WHERE clause, but doing the JOIN there won't necessarily cause it, but there could be bigger temp files as VFP sorts through everything.

>Are you sure about that? I thought you only got a Cartesian product if you coded the Where wrong.
>
>(I also prefer Join for the purpose of joining tables, and Where for filtering).