where not in If the amount of data is too large, you can use not exists to write the statement.

If there is the following statement:

select?distinct?phone_number?from?zj_jituan_3g?where?phone_number?not?in?(select?phone_number?from?zj_34g_201512 );

Can be rewritten as:

select?distinct?a.phone_number?from?zj_jituan_3g?a?where?not?exists?

(select?1?from?zj_34g_201512?b?where?a. phone_number=b.phone_number);