?
Solved

Video examples for Inner join with 2 databases

Posted on 2010-01-06
1
Medium Priority
?
167 Views
Last Modified: 2012-05-08
Does anyone have any links to show how to INNER join 2 tables from 2 different databases ?


Thanks
fordraiders

0
Comment
Question by:Fordraiders
1 Comment
 
LVL 75

Accepted Solution

by:
Aneesh Retnakaran earned 2000 total points
ID: 26192691
This is straightforward if those two databases are on the same server , all you need is to use a 3 part names for the objects

SELECT a.*
FROM database1.schemaName.TableName a
INNER JOIN Database2.SchemaName.TableName b ON a.Somekey = b.SomeKey
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This is basically a blog post I wrote recently. I've found that SARGability is poorly understood, and since many people don't read blogs, I figured I'd post it here as an article. SARGable is an adjective in SQL that means that an item can be fou…
There have been several questions about Large Transaction Log Files in SQL Server 2008, and how to get rid of them when disk space has become critical. This article will explain how to disable full recovery and implement simple recovery that carries…
Loops Section Overview
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question