参考手册

参考手册

实例 PostgreSQL 使用 NOT IN(SELECT) 运算符

 
SELECT * FROM customers
WHERE customer_id NOT IN (SELECT customer_id FROM orders);        
                    

输出结果

 customer_id |            customer_name             |  contact_name  |         address         |  city  | postal_code | country
-------------+--------------------------------------+----------------+-------------------------+--------+-------------+---------
          22 | FISSA Fabrica Inter. Salchichas S.A. | Diego Roel     | C/ Moralzarzal, 86      | Madrid | 28034       | Spain
          57 | Paris specialites                    | Marie Bertrand | 265, boulevard Charonne | Paris  | 75012       | France
(2 rows)