Query two databases in asp and asp.net
Posted on 2009-04-16
I have two databases, DB1 and DB2
I need to make a query out of both see below statement sample of what i want to do:
SELECT FirstName "of DB2", LastName"of DB2", FirstName "of DB1", LastName"of DB1"
FROM Mailing List "of DB2", Mailing List "of DB1"
WHERE FirstName "of DB2" = FirstName "of DB1" ;
What do i need to do and how must my query look like in order to let the query work.
How do i need to create my connections for asp code and asp.net code as i need to make the query work in both languages?