mysql select x_MySQL SELECT x FROM a WHERE NOT IN(SELECT x FROM b) – 意外结果

我期望下面第三个查询的结果包含id = 732。没有这是为什么？

mysql> SELECT id FROM match ORDER BY id DESC LIMIT 5 ;

+------------+

| id |

+------------+

| 732 |

| 730 |

| 655 |

| 458 |

| 456 |

+------------+

5 rows in set (0.00 sec)

mysql> SELECT id FROM email ORDER BY id DESC LIMIT 5 ;

+------------+

| id |

+------------+

| 731 |

| 727 |

| 725 |

| 724 |

| 723 |

+------------+

5 rows in set (0.00 sec)

mysql> SELECT * FROM match WHERE id NOT IN ( SELECT id FROM email ) ;

Empty set (0.00 sec)

表email.id中有三个NULL条目，match.id中没有NULL条目。