取大表差级
大表连小表,小表 is null
select count(*) from jiesuan_xd_temp_1 a left join jiesuan_xd_temp_t_1 b on a.mobile = b.mobile where b.mobile is null;
取小表差级
小表连大表,大表 is null
大表连小表,小表 is null
select count(*) from jiesuan_xd_temp_1 a left join jiesuan_xd_temp_t_1 b on a.mobile = b.mobile where b.mobile is null;
取小表差级
小表连大表,大表 is null