Anyone have any tips for the correct syntax to use in the SQL command to join a table from an external server and database? This works in a straight sql query with brackets around the server name, but Crystal rejects that with an error. It also works to manually select the tables from each connection, but I need to use an SQL command because the join criteria requires conversion of the data with a REPLACE command on one of fields.
I have tried: server.database.owner.table
and [server].database.owner.table
I have tried: server.database.owner.table
and [server].database.owner.table