Essential Books

Using IN clause with a subquery

suggest change 
SELECT * 
FROM customers 
WHERE id IN (
    SELECT DISTINCT customer_id 
    FROM orders
);

The above will give you all the customers that have orders in the system.

Found a mistake? Have a question or improvement idea? Let me know.

Feedback about page:

Feedback:
Optional: your email if you want me to get back to you:

IN clause:
* IN clause
* Simple IN clause
* Using IN clause with a subquery
Table Of Contents