mysql - 选择没有地址的客户

Question

有两个表 ps_customer 和 ps_address。

ps_customer contains: id_customer and customer.email
ps_address contains: id_customer and few other fields.

我想选择 ps_address 表中不存在数据的客户。我正在使用 SQL 查询:

SELECT id_customer, customer.email FROM ps_customer 
WHERE id_customer NOT IN SELECT id_customer FROM ps_address;

但它会抛出错误，查询 SELECT id_customer FROM ps_address

Answer 1

您需要对这两个表进行 LEFT OUTER JOIN。

SELECT PSC.id_customer, PSCcustomer.email
FROM ps_customer PSC
LEFT OUTER JOIN ps_address PSA on PSC.id_customer = PSA.id_customer 
WHERE PSA.id_customer IS NULL