General information
Category:
Coding, syntax & commands
-I did not say SQL "required" aliases.
-I did not mention a concern about uniqueness.
-I clearly stated that I had been taught to always prefix table alias when accessing more than one table in a SQL-SELECT statement.
-I asked _Marc_ if it "helped."
>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.
My point exactly.
>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.
Gee, thanks.
>I just had to respond because I've never seen a useful response from you...
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only