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