- 取得連結
- X
- 以電子郵件傳送
- 其他應用程式
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;
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;
留言