Liveware Publishing Support Forum

Tom,____Many thanks for the example.____I neglected to refer to the SQL 2000 server within my select statement.____It now reads :-____select alias1."field", alias2."field"__from __"server"."database1"."dbo"."table1" alias1,__"server&qu...

Tom____Many thanks for your posting.____I am still getting the same error but I am sure this is because my select statement syntax for the name and owner of the database is wrong.____Any chance you might post an example of the syntax you are using ?____Thanks once again for your help !!!

Hi - I am new to R&R, having recently purchased SQL Edition v9.0.____I understand that Auto SQL will not allow table joins across databases and that a User SQL statement is required.____I have established 2 data source connections to SQL Server 2000.____My problem is that when I construct the Us...