SQL left join 查询

2013-03-08 06:48:42 239 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

zhangzhenshuang 墨衍会员 · AI 创作全网分发关注 + 加入社区

SQL Server使用 LEFT JOIN ON LIKE进行数据关联查询这是来新公司写的第一篇文章，使用LEFT JOIN ON LIKE处理一下这种问题： SQL视图代码如下： CREATE View [dbo].[VI_SearchCN] AS --搜索产品的文件 ( select upload.FileId as ID,upload.Name as Title,upload.Name as FileTxt,con.TypeId as ... 阅读详情

with tb1 as
(select count(uid) as totalregister,ggsiteid
from UserSystem where ggsiteid
in(select code from PromotionCode where scode=102013)
and ( regdate between '2013-03-05' and '2013-03-08') group by ggsiteid )
, tb2 as
(select sum(a.paymoney) as totalmoney,count(distinct(a.uid)) as totalpay,
b.ggsiteid
from user_czhistory as a
left join
(select regdate,uid,ggsiteid from usersystem
where ggsiteid in(select code from PromotionCode where scode=102013)
and regdate>='2013-03-05' and regdate<'2013-03-08'
)
as b
on a.uid=b.uid
where a.updatetime<=dateadd(dd,1,b.regdate)
group by b.ggsiteid)

select * from tb1 left join tb2
on tb1.ggsiteid=tb2.ggsiteid

表tb1数据：
1516 1116
1459 1117
3457 1118
890 1119
1031 1122

如果表tb2数据为：
30 1 1117
查询超慢，不出来
如果数据为：
290 5 1117
610 3 1118
1000 2 1119
10 1 1122
则可以查询出来
这是什么原因

...全文