SQL示例:
SELECT
cz.`客户姓名`,
cz.`客户电话`,
cz.`省份`,
cz.`城市`,
wxs.invite_code,
wxs.self_invite_code,
CASE
WHEN cz.`客户电话` NOT IN ( SELECT phonenumber FROM as_user_info_wxs ) THEN
'未添写手机号或未注册'
WHEN wxs.invite_code IS NULL THEN
'1'
WHEN wxs.invite_code = wxs.self_invite_code THEN
'2'
WHEN wxs.invite_code <> wxs.self_invite_code THEN
'3'
WHEN wxs.self_invite_code IS NULL
AND wxs.invite_code IS NOT NULL THEN
'4' ELSE NULL
END AS '客户类型'
FROM
test.czhk cz
LEFT JOIN test.as_user_info_wxs wxs ON cz.`客户电话` = wxs.phonenumber
SQL说明:
CASE判断用法:
CASE
WHEN 字段1 条件 THEN 动作
WHEN 字段2 条件 THEN 动作
ELSE ......
END
连表查询LEFT_JOIN用法:
LEFT JOIN 库名.表名 别名 ON 条件