OpenDatabase1() OpenDatabase2() Command.Connection = ConDB Command.CommandType = CommandType.Text Command.CommandText = "SELECT d1.Name,d2.Medium FROM Database1.Table1 AS d1, Database2.Table2 AS d2 WHERE d1.ID = d2.ID" ObjDtReader = Command.ExecuteReader If ObjDtReader.Read = True Then Var1 = ObjDtReader("Name") Var2 = ObjDtReader("Medium") End If ObjDtReader.Close() ConDB.Close()</pre>
SELECT d1.Name,d2.Medium FROM Database1.dbo.Table1 AS d1, Database2.dbo.Table2 AS d2 WHERE d1.ID = d2.ID
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)