实例 PostgreSQL NOT EXISTS 运算符实例

SELECT customers.customer_name

FROM customers

WHERE NOT EXISTS (

  SELECT order_id

  FROM orders

  WHERE customer_id = customers.customer_id

);