编辑代码

USE ds_db01
SELECT customer_id,customer_name
FROM customer_inf
WHERE customer_id
NOT IN
(SELECT customer_id FROM order_masterl)