>I disagree.
>IN (SELECT FROM listTable without a WHERE) is not similar to a join, and you ( if want ) can optimize the UPDATE as the IN ()
>Of course, if RECCOUNT(listTable) > RECCOUNT(updateTable) the scan of updateTable can to be faster.

Hi Fabio,

I wasn't talking in general, I was talking about capabilities of SQL engine in VFP. In general, it is possible to optimize conditions like that and I am sure there are SQL engines that do.

Thanks,
Aleksey.