SQL query on two datbase

[parminder]

Hi all,

Can we run a SQL query from ADO.net

For example TABLE1 is in DATABASE1 and TABLE2 is in DATABASE2

can we run query likey this (as concept, not syntax) :

select * from table1,table2 from database1,database2 where table1.Field1=table2.Field2


==> here Field1 and Field2 are same type of fields in Table1 and Table2 respectively


I found related information here

Thanks

[parminder]

No senior member has read ?

[Pirate]

use two different queries on the two tables , and fill the datasets with returned values , merge them . Use Find method to look for any value . Try that .

[parminder]

Thanks Pirate

I will try it.

[techgnome]

ORR....
You can

SELECT *
FROM Table1 T1
INNER JOIN db2Name..Table2 T2
  ON T1.Field1=T2.Field2