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).
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer