From: Peter Abilla <[EMAIL PROTECTED]>
> In this example, I have the table 'bar' and the column 'fooID'.
It sounds to me like you've actually got two tables. If this is the case, you can do
something like:
SELECT bar.foo
FROM bar, baz
WHERE baz.fooID in (baz.fooID)
Which would give you all of the bar records whos fooID links to baz.fooID. If you
really are working with just one table, then I suspect that you haven't told us
everthing.
If you did this:
> SELECT foo
> FROM bar
> WHERE fooID in (bar.fooID)
you'll probably get every record in the table. By any chance, is bar.fooID a delimited
list of IDs?
---
Rodney Broom
President, R.Broom Consulting
http://www.rbroom.com/
sql
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
