Column needed from another database 1

[charbrad]

I have two databases database1 & database2. I can retrieve most of my information from a table in database1, but there is a column from a table in database2 that I need to complete my query. Is there a way to join this column from database2 to my ouput from data retrieved from database1?

 

[SgtJarrow]

SQL2005??? If so, try:

JOIN servername.databasename.schemaname.tablename d2 ON d1table.idcolumn = d2.idcolumn

and in the SELECT portion of your query:

d2.columnname

=======================================
People think it must be fun to be a super genius, but they don't realize how hard it is to put up with all the idiots in the world. (Calvin from Calvin And Hobbs)

Robert L. Johnson III
CCNA, CCDA, MCSA, CNA, Net+, A+, CHDP
VB/Access Programmer

 

[charbrad]

We are using SQL2000

 

[SgtJarrow]

Haven't done any 2000 in a while, but should be something like if on the same server (notice the two dots....dbo implication for sql2000 if I remember correctly):

JOIN databasename..tablename d2 ON d1table.idcolumn = d2.idcolumn

=======================================
People think it must be fun to be a super genius, but they don't realize how hard it is to put up with all the idiots in the world. (Calvin from Calvin And Hobbs)

Robert L. Johnson III
CCNA, CCDA, MCSA, CNA, Net+, A+, CHDP
VB/Access Programmer

 

[charbrad]

Thank you....have a star!