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 yo
Question about SQL "WHERE IN" syntax:
I know that something like this is fine to do:
(1)
SELECT foo
FROM bar
WHERE fooID in ('1','2')
In the example above, the parenthesis includes the itemized fooID's. But, I
want to do a similar thing where instead of the actual fooID's in the WHERE
IN cl