USE ds_db01 SELECT c.customer_name, o.district_money FROM customer_name as c LEFT JOIN order_masterl as o ON c.customer_id=o.customer_id WHERE o.district_money<1000 OR o.district_money IS NULL