Home > IT Answers > Development > Join and manipulate data from two separate da...
wbrannon18
0 pts.
 Join and manipulate data from two separate databases
SQL, Web site design & management, Development
I'm using SQL2000. How can I join and manipulate tables from two different databases?

Thanks,
wbrannon18
ASKED: Nov 21, 2005  8:33 AM GMT
UPDATED: November 21, 2005  3:39:38 PM GMT
RELATED QUESTIONS
randym
1,740 pts.
Answer Wiki:
preface your table with the database. ex.

select ... from db.owner.table

if you don't need to specify the owner you can do:

select * from db..table
Last Wiki Answer Submitted:  Nov 21, 2005  12:53 AM (GMT)  by  randym   1,740 pts.
To see other answers submitted to the Answer Wiki View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



 

How could I apply what you’ve suggested using code?

web.config (

wbrannon18
 0 pts.
 

Yes, the userid you use to connect would need permissions to both databases and tables; but you connect to just one DB. Then the sql statement “select … from db.owner.table inner join db2.owner.table on …..” should work

randym
 1,740 pts.