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
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
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
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