>>For me the problem is that you are not aliasing all your fields as you should always do, even in SQL Server; the fact that this time SQL gets the correct result does not mean that is good practice to let SQL identify the fields by its uniqueness, tomorrow you change one of the participating tables to include a d2 field and your code stops working, the syntax you used here is correct for both FoxPro and SQL and in my opinion the
only one that is correct.
>
>Read the relevant blog post
>
http://blogs.lessthandot.com/index.php/DataMgmt/DBProgramming/dealing-with-the-multi-part-identifier-dWhy did you make me read that post? Isn't the author saying the same thing as I did? I recognize I read it quickly but it seemed to me that it is exactly what I said.
"The five senses obstruct or deform the apprehension of reality."
Jorge L. Borges?
"Premature optimization is the root of all evil in programming."
Donald Knuth, repeating C. A. R. Hoare
"To die for a religion is easier than to live it absolutely"
Jorge L. Borges