>For VFP 6 to take advantage of optimizing a multi-table join on single field keys, must the field name be identical in both tables?
>
>For example:
>
>CUSTOMER.CID I(4) AND ORDER.CID I(4)
>
>verses
>
>CUSTOMER.CID I(4) AND ORDER.OCID I(4)
No. What can influence optimization, however, is whether or not you have an an index on the field, in each of the tables. Usually, it is best to have the index.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)