Re: [GENERAL] finding items with 0 rels for a 0 to many relationship

2007-06-24 Thread danmcb
thanks both for this. I haven't got around to writing this part of the code yet, but will do soon. I appreciate the pointers. On 21 Jun, 19:13, [EMAIL PROTECTED] (Michael Glaesemann) wrote: On Jun 21, 2007, at 11:57 , Josh Tolley wrote: On 6/21/07, danmcb [EMAIL PROTECTED] wrote: Hi I

[GENERAL] finding items with 0 rels for a 0 to many relationship

2007-06-21 Thread danmcb
Hi I have two tables, say A and B, that have a many-to-many relationship, implemented in the usual way with a join table A_B. How can I economically find all the rows in table A whose id's are not in A_B at all (i.e. they have zero instances of B associated)? Thanks Daniel

Re: [GENERAL] finding items with 0 rels for a 0 to many relationship

2007-06-21 Thread Josh Tolley
On 6/21/07, danmcb [EMAIL PROTECTED] wrote: Hi I have two tables, say A and B, that have a many-to-many relationship, implemented in the usual way with a join table A_B. How can I economically find all the rows in table A whose id's are not in A_B at all (i.e. they have zero instances of B

Re: [GENERAL] finding items with 0 rels for a 0 to many relationship

2007-06-21 Thread Michael Glaesemann
On Jun 21, 2007, at 11:57 , Josh Tolley wrote: On 6/21/07, danmcb [EMAIL PROTECTED] wrote: Hi I have two tables, say A and B, that have a many-to-many relationship, implemented in the usual way with a join table A_B. How can I economically find all the rows in table A whose id's are not