>It would not have worked in the Command Window if the SQL required table aliases on the fields. Fox tells you right away when a field is not unique in a query.
>
>What do you mean about 'no assurance' as to which table is open? If the tables are opened prior to the SQL, then Fox utilizes those; otherwise, it would search along your path settings to open the tables specified in the FROM clause.
>
>I just had to respond because I've never seen a useful response from you...
Jack,
Interesting observation since your message is inaccurate. SQL
ALWAYS reopens any tables with a USE AGAIN if they are already open. There can be a small performance boost if the tables are already open because USE AGAIN is faster than USE the first time.