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