34,594
社区成员
发帖
与我相关
我的任务
分享
uid name isNew
1 a true
2 b true
3 c true
4 d false
....
vid uid isGold
1 3 true
2 1 false
3 2 true
3 4 true
....
select
a.name
from
DB1..[user] a , DB2..[vip] b
where
a.uid =b.uid and a.isNew='true' and b.isGold='true'
select a.* from DB1.dbo.[user] a,DB2.dbo.vip b
where a.uid=b.uid and a.isNew='true' and b.isGold='true'
--在uid字段建立索引
--50w数据不算多,没有问题
--刚才写错了,少了个连接条件,抱歉。
select a.name
from DB1.dbo.[user] a,DB2.dbo.[vip] b
where a.uid = b.uid and a.isNew='true' and b.isGold='true'
select a.name
from DB1..[user] a , DB2..[vip] b
where a.uid =b.uid and a.isNew='true' and b.isGold='true'
select a.* from DB1.dbo.[user] a,DB2.dbo.vip b
where a.isNew='true' and b.isGold='true'
select a.* from DB1.dbo.user a,DB2.dbo.vip b
where a.isNew='true' and b.isGold='true'