ASP Forum linking two tables in different databases? pussy cat | Posted 5:20am 9. April 2008 Server Time | I have two sets of related data in two databases, I want to llink them when I query them I'm thinking this is pie in the sky stuff but does anyone know if it is or isn't possible? thanks katy8439 | Posted 7:03am 9. April 2008 Server Time | What database(s) are you running? pussy cat | Posted 4:05am 10. April 2008 Server Time | ms sql 2000 katy8439 | Posted 5:50am 10. April 2008 Server Time | Have a look at http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1385691&SiteID=1 The format needs to be databasename.databaseowner.table pussy cat | Posted 4:56am 15. April 2008 Server Time | thanks got it working :) hunain11 | Posted 11:00pm 29. June 2008 Server Time | thanks hunain11 | Posted 11:03pm 29. June 2008 Server Time | tanks Reply to Post linking two tables in different databases? Back to Forum Page