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