getting rows that dont exist

[Canman2005]

Hi all

 

I have the following statement

 

SELECT * FROM customers m INNER JOIN orders o ON m.id = o.customers_id

 

this gets all `customers` which have a row in the `orders` table

 

How can I alter this to get all `customers` which don't have a row existing in the `orders` table?

 

Thanks in advance

[sKunKbad]

The following is not real code (obviously), but is how I'd try to make it work:

 

SELECT customer_id from orders

 

// php that puts all query results in an array

 

SELECT id from customers WHERE id NOT (in the array of customer who have orders)

[Canman2005]

Thanks, I tried

 

SELECT * FROM customers WHERE id NOT (SELECT m.id FROM customers m INNER JOIN orders o ON m.id = o.customers_id) ORDER BY datetime DESC

 

But that doesnt seem to do anything and produces an error

[sasa]

SELECT * FROM (customers m LEFT JOIN orders o ON m.id = o.customers_id) WHERE o.id IS NULL