Doc:
Try this...
SELECT C.domain, email, telephone, count(*)
FROM Customers AS C LEFT JOIN
Orders AS O ON O.domain=C.domain
GROUP BY C.domain, email, telephone ;
Cheers,
Kent
[fodder=SQL]
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
