Looking for ways to compare

[tobermory20]

Hello,

I am struggling with trying to compare two different database tables in different database. in theory it seems managable, but I can seem to make it work. where is what I did in Access but need to translate for MS SQL Server

SELECT Table2.server
FROM Table2 LEFT JOIN Table1 ON Table2.server = Table1.server
GROUP BY Table2.server, Table1.server
HAVING (((Table2.server) Is Not Null) AND ((Table1.server) Is Null));

thanks in advance...
~ T

 

[mrdenny]

To access a database on another database you need to use the three part name of the object.

select *
from table1
join database2.dbo.table2 as table2 on table1.col1 = table2.col3

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog

 

[tobermory20]

mrdenny,

Thanks for the reply. Here's my situation, I have two different Servers I am trying to access tstmd and tstsql both have a database I want to use. So do I need something like

select *
from table1
join [COLOR=red]server.[/color]database2.dbo.table2 as table2 on table1.col1 = table2.col3

 

[SQLSister]

not only do you need a 4 part name but you need to set up linked servers. Look up how to do that in Books on line.

"NOTHING is more important in a database than integrity." ESquared

 

[SQLDenis]

if this is a one time thing then look up OPENROWSET, if you are going to do this many times then lookup sp_addlinkedserver in BOL (Books On Line)

Denis The SQL Menace
--------------------
SQL Server Code,Tips and Tricks, Performance Tuning
SQLBlog.com, Google Interview Questions