select query with multiple tables in difference sql server objects.

  • Thread starter Thread starter ryanvan75
  • Start date Start date
R

ryanvan75

Hi, All

I'm work on a query that database located in two difference
objects....once with grant permission belong to MS SQL Group and others
are (Local) server database. In server group, I don't have permission
to create a table but able to test the data tables on Local server to
retrieve data fine.

How would create a query gather information from MS SQL Server Group
tables (advo & advosum) and (Local) server table
(champaignaddress)?????

Thank you
RV,
 
These are two different servers and you want to make one query? You can't
without multiple connections and multiple steps (querying one then using a
result from that table to query the other server in a WHERE clause). Also,
selecting from a local SQL Server won't be seen by anyone on a web site
unless your server is open to the world and your PC is always on. Why would
you want to do this? To test locally you can just use the connection to
your live database or replicate it on your local one. And you should have
the same permissions on both. Try the SQL Server news group if you have
questions on setting up your server.
 
Back
Top