>local cJoinSqlServer >cJoinSqlServer = "SQL2Name.dbo." >cSqlSelect = "select * from mytable join " + cJoinSqlServer + "MyTable2 on MyTable.pk_field = MyTable2.pk_field" >>The above syntax works.
>local cJoinSqlServer >cJoinSqlServer = "SQL2Name.dbo." >cSqlSelect = "select * from mytable join " + cJoinSqlServer + "MyTable2 on MyTable.pk_field = " + cJoinSqlServer + "MyTable2.pk_field" >>
local cJoinSqlServer cJoinSqlServer = "SQL2Name.dbo." cSqlSelect = "select * from mytable as T1 join " + cJoinSqlServer + "MyTable2 as T2 on T1.pk_field = T2.pk_field"