Multi Database Joins - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

Multi Database Joins

Author

Topic

RobinM
Starting Member

7 Posts

Posted - 2009-03-06 : 15:58:56

Hi! New here. Just found this forum. What a great bunch of info here. I am having a brain freeze, can someone remind me, what is the syntax for joining tables across multiple databases?

I thought it was:

databaseName.tableName.columnName

but it's not working for me.

Thanks,Robin

mfemenel
Professor Frink

1421 Posts

Posted - 2009-03-06 : 16:04:49

you're missing the schema name. (or owner depending on your version)

database.schemaORowner.tablename.columnName

Mike
"oh, that monkey is going to pay"

RobinM
Starting Member

7 Posts

Posted - 2009-03-06 : 16:06:16

oh duh! :) Thanks so much!

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources