20,808
社区成员
发帖
与我相关
我的任务
分享
select t.cookie,
t.datetime,
t.province,
t.city,
t.ostype,
t.ip,
c.cookie,
if(c.cookie is null,1,0) as new_old_user
from log_test t
left join cookie_dw c
on (t.cookie = c.cookie)
where t.cookie='1234567==';
select t.cookie,
t.datetime,
t.province,
t.city,
t.ostype,
t.ip,
t.cookie,
if(c.cookie is null,1,0) as new_old_user
from log_test t
left join cookie_dw c
on (t.cookie = c.cookie)
where t.cookie='1234567==';
这样就可以了,但是感觉没必要。你的查询结果就是所谓的异常结果,left join也只能查询到这样的结果。非要所谓的正确结果的话将c.cookie替换为t.cookie即可[/quote]
不对啊,是不是我表述不清楚,可以加我QQ详说下吗?[/quote]
1252492309select t.cookie,
t.datetime,
t.province,
t.city,
t.ostype,
t.ip,
t.cookie,
if(c.cookie is null,1,0) as new_old_user
from log_test t
left join cookie_dw c
on (t.cookie = c.cookie)
where t.cookie='1234567==';
这样就可以了,但是感觉没必要。你的查询结果就是所谓的异常结果,left join也只能查询到这样的结果。非要所谓的正确结果的话将c.cookie替换为t.cookie即可[/quote]
不对啊,是不是我表述不清楚,可以加我QQ详说下吗?select t.cookie,
t.datetime,
t.province,
t.city,
t.ostype,
t.ip,
t.cookie,
if(c.cookie is null,1,0) as new_old_user
from log_test t
left join cookie_dw c
on (t.cookie = c.cookie)
where t.cookie='1234567==';
这样就可以了,但是感觉没必要。你的查询结果就是所谓的异常结果,left join也只能查询到这样的结果。非要所谓的正确结果的话将c.cookie替换为t.cookie即可