34,590
社区成员
发帖
与我相关
我的任务
分享
select m.*
from servername.b1.dbo.t1 m , servername.a1.dbo.a1 n
where m.id = n.id and n.ONLINE = 'true'
select m.*
from b1..t1 m , a1..a1 n
where m.id = n.id and n.ONLINE = 'true'
select m.*
from servername.b1.dbo.t1 m , servername.a1.dbo.a1 n
where m.id = n.id
select m.*
from b1..t1 m , a1..a1 n
where m.id = n.id
SELECT A.* FROM DBA.DBO.A1 A INNER JOIN DBB.DBO.B1 B ON A.ID=B.ID AND A.ONLINE='true'