Join databases Query in SQL

[mentasses]

I have two databases, EMPLOYEES and VEHICLES

I want to run a SELECT query using tables from each database. I have tried using the full address to each table but this does not work.
e.g.
SELECT employee.details.surname,
vehicles.companycars.model
FROM employee.details INNER JOIN vehicles.companycars
ON vehicles.companycars.regno = employee.details.regno

Can anyone tell me where I am going wrong?

 

[bhags]

specify the name of database user ('dbo') in the query

For example:

Try below one

SELECT a.surname,
b.model
FROM employee.dbo.details a INNER JOIN vehicles.dbo.companycars b
ON a.regno = b.regno