注册 登录
编程论坛 SQL Server论坛

求一个好欧巴帮忙看下,这么段的句子为啥跑出来是空的?

jorsan 发布于 2014-11-27 17:13, 486 次点击
select
    a.os,
    a.country,
    datediff(b.member_gmt_create,a.hp_stat_date) as PP,
    count(distinct a.imeisi) as geshu
from bdl_en_app_wdm_v3_user_track_d a
join idl_en_ent_signin_fdt0 b
on  a.session_id = b.session_id
and a.newly_imeisi is not null
and a.hp_stat_date>='2014-06-20'
and b.hp_stat_date>='2014-06-20'
group by
    a.os,
    a.country,
    datediff(b.member_gmt_create,a.hp_stat_date)
统计app用户 从装机时间到注册时间的差 的用户数量。
就是用户在装机后一天注册的有XX个,后两天注册的有XXX个·····这样

2 回复
#2
tlliqi2014-11-28 10:07
join处不对吧
#3
yh9106152014-12-01 12:50
我觉得是这里的问题:
from bdl_en_app_wdm_v3_user_track_d as a
join idl_en_ent_signin_fdt0 as b
1