MSSQL Cross Database Query


SELECT top 200
u.name,c.company_name
FROM dbo.user AS u WITH (nolock)
LEFT JOIN  [DB1toDB2].company_db.dbo.company AS c
ON u.user_id = c.user_id
WHERE u.state = 1
ORDER BY u.name ASC;

留言