... 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
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
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 '$bar_id'