Hi Mike, You'll need to use a LEFT JOIN instead of an INNER JOIN.
LEFT JOIN returns mismatches between tables. Try something like: SELECT customers.company, count(invoices.id) as invcount FROM customers LEFT JOIN invoices ON customers.id= invoices.customer_id GROUP BY customers.id ORDER BY customers.creation desc Hope this helps, Paul -----Original Message----- From: Brian Dunning [mailto:[EMAIL PROTECTED] Sent: 02 November 2005 16:22 To: mysql@lists.mysql.com Subject: Not finding customers without invoices I'm trying to find a list of customers including a count of all their invoices, but it's not including customers who have no invoices - and it should. What's broken? SELECT customers.company, count(invoices.id) as invcount FROM customers, invoices WHERE customers.id= invoices.customer_id GROUP BY customers.id ORDER BY customers.creation desc Thanks! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
