SELECT * FROM `invoice_details` d LEFT JOIN sellers s ON d.seller_id = s.seller_id AND d.project_id = s.project_id WHERE s.name is null and d.project_id = '9'