SQL Query with 2 databases

Question

I have this Classic ASP application running with SQL Server. I use the following query:

sql = "SELECT TOP 30 r.RMANumber, r.CompanyName, r.ContactName, r.Country, r.Phone, r.IssuanceDate, r.DateReceived, r.CreatedBy " & _
      "FROM rma r " & _
      "WHERE r.IssuanceDate >= '" & startDate & "' AND r.IssuanceDate <= '" & DateAdd("d", 1, CDate(endDate)) & "' AND r.RMAClosed = 'No' " & _
      "ORDER BY IssuanceDate DESC"

I'd like to add an INNER JOIN to it but the INNER JOIN would look in the different database. Can I do this:

sql = "SELECT TOP 30 r.RMANumber, r.CompanyName, r.ContactName, r.Country, r.Phone, r.IssuanceDate, r.DateReceived, r.CreatedBy " & _
     "FROM [database1].[dbo].[rma] r " & _
     "INNER JOIN [database2].[dbo].[users] u " & _

@Brasciole: Yes, you can. Take a look at this , give it a shot and come back with what you tried and any questions you have. — GVashist
– GVashist, Commented Jan 27, 2015 at 21:49

Rigel1121 · Accepted Answer · 2015-01-28 02:09:40Z

1

If your other database is in another server. Put the IP address of the server as shown below:

sql = "SELECT TOP 30 r.RMANumber, r.CompanyName, r.ContactName, r.Country, r.Phone, r.IssuanceDate, r.DateReceived, r.CreatedBy " & _
      "FROM [database1].[dbo].[rma] r " & _
      "INNER JOIN [ip address of other server here].[database2].[dbo].[users] u " & _

Note: Be sure you're connected and have an access to that server to where your other database resides.

answered Jan 28, 2015 at 2:09

Rigel1121

2,0171 gold badge19 silver badges25 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

SQL Query with 2 databases

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related