How Can I do this?

If I understand you correctly you're getting tables from 2 different databases? You'll have to create Views on your databases that access the other. Not sure what database you're using. On MS SQL, creating VIEWS is pretty easy to do as long as you have "admin" rights.
Hope this helps.

I think you can use header.asp and footer.asp file to pull data (template) from another database and display it on the web page.
Check "How to integrate ASPRunnerPro application into existing website" tutorial at

http://www.xlinesoft.com/asprunnerpro/tutorial.htm

I think you can use header.asp and footer.asp file to pull data (template) from another database and display it on the web page.

I know that, the only thing is I need to do it the other way around. I create and host the asp runner projects. The website that will need to display these projcets is hosted somewhere else and runs on drupal. However it provides the ability to get stuff from different sources, for example the asprunner projects I host.
On a technical view I need to find the base path variable so the links will link to the page that runs on drupal with the query string instead of the local pages I host

I guess you can use an iframe to display ASPRunnerPro-generated application. Not sure what else to recommend.