Re: select records not in a *particular* many-to-many relationship

2006-04-18 Thread Marco Carbone
gerald_clark wrote: I've checked the archives and found an explanation as to how the check if a record is not in a many-to-many table. The answer to that is somewhat simple and clear to me. But here's my problem: how do you check if a record doesn't have a *particular* many-to-many relati

Re: select records not in a *particular* many-to-many relationship

2006-04-18 Thread gerald_clark
I've checked the archives and found an explanation as to how the check if a record is not in a many-to-many table. The answer to that is somewhat simple and clear to me. But here's my problem: how do you check if a record doesn't have a *particular* many-to-many relationship? As in, let's

Re: select records not in a *particular* many-to-many relationship

2006-04-18 Thread Peter Brawley
Marco, I've checked the archives and found an explanation as to how the check if a record is not in a many-to-many table. The answer to that is somewhat simple and clear to me. But here's my problem: how do you check if a record doesn't have a *particular* many-to-many relationship? As in,

select records not in a *particular* many-to-many relationship

2006-04-18 Thread Marco Carbone
Hey all, I've checked the archives and found an explanation as to how the check if a record is not in a many-to-many table. The answer to that is somewhat simple and clear to me. But here's my problem: how do you check if a record doesn't have a *particular* many-to-many relationship? As i