Hi Guys,

I have two set of databases, namely database1, database2. However, both of these db contains a member table with similar fields.

How do I do a select statement from both databases?

I tried the following statement but failed.

SELECT FROM dbo.database1.member as D1 INNER JOIN dbo.database2.member AS D2 ON D1.MemberID = D2.MemberID

Please advise.

Thanx in advance.

Regards.

KT