Inner Join On Two Separate Databases

I need to do a inner join on tables from two separate databases.  I understand that you can do this by using this type of syntax:

select a.col1, b.col2
from db1.dbo.tab1 a, db2.dbo.tab2 b
where a.col1 = b.col2

however, how do I reference the two databases in the following code?

Thanks,

Tim

 

Function GetConnectionString() As StringDim ConnectionString As String = ConfigurationManager.ConnectionStrings("MainWeb").ConnectionString

Return ConnectionString

End Function

 Using conn As New SqlConnection(GetConnectionString())

conn.Open()

Dim sql As String

sql = "SELECT CaskInfo.CaskID, CoCInfo.CoCName, AmendmentInfo.AmendmentName FROM CaskInfo INNER JOIN CoCInfo ON CoCInfo.CoCID = CaskInfo.CoC INNER JOIN AmendmentInfo ON AmendmentInfo.AmendmentID = CaskInfo.Amendment WHERE "For i = 0 To UBound(words)

If i > 0 Then sql = sql + " OR "

sql = sql + "(CoCInfo.CoCName + ' ' + AmendmentInfo.AmendmentName) LIKE '%" + words(i) + "%'"

Next

' lblResults.text = sql' Exit Sub

Dim com As SqlCommand = New SqlCommand(sql, conn)

Dim result As SqlDataReader = com.ExecuteReader()

Dim SearchResults As StringWhile result.Read()

SearchResults = SearchResults + result.GetInt32(0).ToString + " " + result.GetString(1) + " " + result.GetString(2) + "<br>"

End While

result.Close()

lblResults.text = SearchResults

conn.Close()

End Using