Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL - BLUES
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Miscellaneous
Thread ID:
00146533
Message ID:
00146689
Views:
26
-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
Map
View

Click here to load this message in the networking platform