My mistake. I failed to mention that there are two tables, bar and baz. And, I found the answer to my question. Thanks everybody.
On 12/2/02 5:52 PM, "Adolfo Bello" <[EMAIL PROTECTED]> wrote: > Isn't this sort of impossible? > You are asking for something like "a set which contains as an element > the set itself" > > WHERE fooId IN (fooId) > > Adolfo > >> -----Original Message----- >> From: Peter Abilla [mailto:[EMAIL PROTECTED]] >> Sent: Monday, December 02, 2002 1:43 PM >> To: [EMAIL PROTECTED] >> Subject: sql:WHERE IN SYNTAX >> >> >> 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 clause, I reference a >> column that contains the fooID's, like: >> >> (2) >> SELECT foo >> FROM bar >> WHERE fooID in (bar.fooID) >> >> In this example, I have the table 'bar' and the column 'fooID'. >> >> Is (2) possible? If not, what other strategies are there? >> Please help. >> >> PSA >> >> >> >> >> --------------------------------------------------------------------- >> 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 >> >> >> >> > > > --------------------------------------------------------------------- > 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 > > > --------------------------------------------------------------------- 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
