Re: [SQL] grouping a many to many relation set

2004-12-03 Thread Johan Henselmans
On 2-dec-04, at 3:45, Michael Fuhr wrote: On Wed, Dec 01, 2004 at 06:57:54AM +0100, Johan Henselmans wrote: Richard Huxton wrote: I think what's missing here is the explicit statement of which group these belong in. Without a value to sort/group by, there's nothing for your queries to &

Re: [SQL] grouping a many to many relation set

2004-12-01 Thread Johan Henselmans
Richard Huxton wrote: Johan Henselmans wrote: Hi, I am having a problem grouping a many to many relationship with payments and receipts, where a payment can be for multiple receipts, and a receipt can have multiple payments. I got a list of records that are involved in such relations, but now I

[SQL] grouping a many to many relation set

2004-11-29 Thread Johan Henselmans
Hi, I am having a problem grouping a many to many relationship with payments and receipts, where a payment can be for multiple receipts, and a receipt can have multiple payments. I got a list of records that are involved in such relations, but now I don't know how to group them so that all paym