ASP Report

[JamesHumphries]

OK, im making a report in Dreamweaver CS3, using ASP



Im using an SQL Query to collect data from one database on one server, but i also need to get information from another database in another server and display them both directly in a table on one page, as i need to compare each with each other

Is there a way i can do this with one Query??

P.S if you dont understand what i mean, its cause im knew.. just started on ASP you see

Cheers

[DrBunchman]

Are you using MS SQL? If so then yes I know you can do this by saying for instance:

SELECT server1.dbo.dat abase1.table.Co lumn1, server2.dbo.dat abase2.table.Co lumn1 FROM ...

But as far the specific technicalities of it...that is a question for the SQL Server forum. If you post your question in there I am sure that somebody will be able to help you better.

If you are not using MS SQL then I don't know if it can be done but try the database forum for whichever one you are using.

I hope you manage to find the answer you're looking for,

Cheers,

Dr B