As per the question, lets take customer and orders as two tables.
Select * from customer join orders on customer.customerid=orders.customerid Where order.orderid is null
Here we are joining the orders and customer tables using join. Based on common column customerid. And checking for orderid in orders table is null.