Re: [GENERAL] Return t/f on existence of a join

2007-09-21 Thread Jon Sime
Madison Kelly wrote: > I want to create a query that will allow me to say "show me all 'foo' > rows and tell me if a specific 'baz_id' belongs to it". Normally, I > would do this: > > SELECT foo_id FROM foo; > (for each returned row) > { > # Where '$foo_id' is the current 'foo_id' and '$

Re: [GENERAL] Return t/f on existence of a join

2007-09-21 Thread Erik Jones
On Sep 21, 2007, at 2:17 PM, Madison Kelly wrote: ... Or something like that. :) Sorry for so many questions! I have another "how do I create this query?" question, if it's okay. I've got three tables; 'foo', 'bar' and 'baz'. In 'foo' I've got 'foo_id' which is a PK. I've also got a bun

[GENERAL] Return t/f on existence of a join

2007-09-21 Thread Madison Kelly
... Or something like that. :) Sorry for so many questions! I have another "how do I create this query?" question, if it's okay. I've got three tables; 'foo', 'bar' and 'baz'. In 'foo' I've got 'foo_id' which is a PK. I've also got a bunch of other info, but in essence this is the "parent"