Luis,
Thank you for your help.
You pointed me in the right direction:
>You are using VFP's SQL dialect on SQL Server. Both SQLs versions are not the same, they have many >differences. For example you can't use "!" to do a "database!table" reference in SQL Server, you should use >something like in: "database..table" to reference a table in another database (in between the two dots goes >the owner of the database but in some circumstances it can be omitted, I don't remember those >circumstances :) ). So your query could be like this (do not use semicolons between the lines):
>SELECT TableA.lname,TableB.orderdate,TableB.orderamount
>FROM BaseA..TableA TableA
>LEFT OUTER JOIN BaseB..TableB TableB ON TableA.OrderNum = TableB.OrderNum
I ended up qualifying ALL references with the DATABASE..TableName.FieldName.....and it works fine..!!
Thanks again.
David
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement