SELECT c.*
FROM
  customers c
  LEFT JOIN orders o
  ON c.id = o.customerid
WHERE
  o.customerid IS NULL