Re: sql:WHERE IN SYNTAX

2002-12-02 Thread Rodney Broom
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

sql:WHERE IN SYNTAX

2002-12-02 Thread Peter Abilla
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