Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Linking table in two different DB

Status
Not open for further replies.
aishaaa

aishaaa

Programmer
May 1, 2002
21
0
0
AE
Hi,

am new to SQL and never use it before it might be easy one but unfortunately I don’t know the answer ..
I have 2 table in 2 different database I want 2 link them
any idea how to do it ??

thansk

 
Sort by date Sort by votes
Assuming the databases reside on the same server, just qualify the name of the table:

Code: 
SELECT * FROM database_name.owner.table_name

--James
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

grnzbra
  • Locked
  • Question
How Do I Add Column to Middle of Table
Replies
4
Views
169
BobSuruncle
BobSuruncle
BobThornton
  • Locked
  • Question
Drop a table based on the count of records in another table
Replies
13
Views
105
Chris Miller
Chris Miller
scubafrog79
  • Locked
  • Question
Flag record if there two different locations for that record in another table 1
Replies
3
Views
60
Andrzejek
Andrzejek
briangriffin
  • Locked
  • Question
Calculating differences every two rows
Replies
2
Views
94
kjv1611
kjv1611
leifoet
  • Locked
  • Question
Error in Select query
Replies
14
Views
156
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top