On Tue, 25 May 2004 11:50:11 +0100, Paul Owen <[EMAIL PROTECTED]> wrote:
> What I have so far is: > from people, invoice, payments > where people.pid=invoice.pid > and people.pid=payments.pid > group by people.pid; Though it doesn't fix the problem you're asking about, I wanted to note that you'll want to use a left joins. Otherwise, your search only returns people who have made a payment. from people, invoice ;eft join payments on payments.pid=people.pid where people.pid=invoice.pid group by people.pid; As for your original question, it seems like the problem is grouping incorrectly, but it doesn't jump out at me. It's still early here this morning. Ryan Fox -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
