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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

multi-base

Status
Not open for further replies.
robvi

robvi

Programmer
Aug 16, 2002
11
FR
I have a sp in db1 and, inside this sp, I'd like to access a column in db2. How may I have something like :

select * from t1, db2, t3
 
Sort by date Sort by votes
I write the question and here is the answer :
select * from t1, db2..t3

There are 2 points between the database name and the column name.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

marn1997
  • Locked
  • Question
Large data base to back word engineer
Replies
5
Views
119
Andrzejek
Andrzejek
peac3
  • Locked
  • Question
Consolidate multiple rows into single row 1
Replies
4
Views
328
Chris Miller
Chris Miller
peac3
  • Locked
  • Question
split one row into multiple rows... help pls 2
Replies
12
Views
506
Chris Miller
Chris Miller
BobThornton
  • Locked
  • Question
Drop a table based on the count of records in another table
Replies
13
Views
227
Chris Miller
Chris Miller
pabowen
  • Locked
  • Question
Determining Multiple 12 Month Term periods based on Start and End Date
Replies
3
Views
121
pabowen
pabowen

Part and Inventory Search

Sponsor

Back
Top