SELECT T.XZPHONE AS PHONENO FROM T_YWXH_LOG T WHERE T.XZPHONE NOT IN (SELECT T1.PHONE_NO FROM T_YWSK_ACT_LOG T1 WHERE T1.STATE = '1' )AND T.STATE = '0'AND T.DSSTATE = '0' 这是我自己的sql,虽然解决了,但我感觉不是最优的方式,请教一下大家
试试这个: [code=sq] select t1.xzphone from t1 where not exists(select null from t2 where t2.phone_no = t1.xzphone) [/code]
select t1.xzphone from t1 where not exists(select null from t2 where t2.phone_no = t1.xzphone)
试试这个SQL:SELECT TT.PHONENO1 FROM( SELECT T.XZPHONE AS PHONENO1, T1.PHONE_NO AS PHONENO2 FROM T_YWXH_LOG T LEFT JOIN T_YWSK_ACT_LOG T1 on T1.PHONE_NO = T.XZPHONE WHERE T1.STATE = '1' AND T.STATE = '0' AND T.DSSTATE = '0' )TT WHERE TT.PHONENO2 IS NULL
这是我自己的sql,虽然解决了,但我感觉不是最优的方式,请教一下大家
需求很容易实现,关键是要把你想要的效果贴出来。
需求很容易实现,关键是要把你想要的效果贴出来。
需求就是:比如订单表手机号码
号码 状态
1 0
2 0
3 0活动日志表号码 状态1 1
2 1现在号码重复,查第一张表排除到第二张有的号码1和2,只查出来3
[code=sq]
select t1.xzphone
from t1
where not exists(select null from t2 where t2.phone_no = t1.xzphone)
[/code]
select t1.xzphone
from t1
where not exists(select null from t2 where t2.phone_no = t1.xzphone)
FROM(
SELECT T.XZPHONE AS PHONENO1,
T1.PHONE_NO AS PHONENO2
FROM T_YWXH_LOG T
LEFT JOIN T_YWSK_ACT_LOG T1 on T1.PHONE_NO = T.XZPHONE
WHERE T1.STATE = '1'
AND T.STATE = '0'
AND T.DSSTATE = '0'
)TT WHERE TT.PHONENO2 IS NULL