Create Report/Query table from multiple Databases
Is it possible to create a Report/Query table from multiple databases?
example:
SELECT "Date", "Time"
FROM dbo.database1.thisTable
INNER JOIN dbo.database2.thatTable
ON dbo.database1.thisTable.date = dbo.database1.thatTable.date