Am I doing things right? (selecting groups of objects problems)

2004-04-09 Thread chillz
Hello, I've recently came across a problem I couldn't seem to solve right by myself. I have a db with objects table, each of those objects may belong to groups of objects. The number of groups can be about 256 and an object belongs from one to many different groups at once. I cannot find a good

Re: Am I doing things right? (selecting groups of objects problems)

2004-04-09 Thread Garth Webb
On Fri, 2004-04-09 at 09:48, [EMAIL PROTECTED] wrote: Hello, I've recently came across a problem I couldn't seem to solve right by myself. I have a db with objects table, each of those objects may belong to groups of objects. The number of groups can be about 256 and an object belongs

Re: Am I doing things right? (selecting groups of objects problems)

2004-04-09 Thread beacker
Lecho [EMAIL PROTECTED] writes: I have a db with objects table, each of those objects may belong to groups of objects. The number of groups can be about 256 and an object belongs from one to many different groups at once. Lecho, I threw together the following tables/data/queries that I