If I have customers and orders, how do I find the customers with no
orders? Is the methos that I'm using below accurate and the best way?

SELECT *
FROM CUSTOMERS C LEFT OUTER JOIN ORDERS O ON
C.CUST_ID = O.CUST_ID
WHERE O.CUST_ID IS NULL