List:General Discussion« Previous MessageNext Message »
From:Thimble Smith Date:August 6 1999 2:03am
Subject:Re: how many args to SELECT...IN()
View as plain text  
At 21:52, 19990805, Paradox wrote:
>I believe you can accomplish it without using such ugly methods, lets say
>your table of valid baz's is in "baz":
>
>SELECT bar.foo FROM bar,baz WHERE bar.foo = baz.foo;

There are times when it's necessary, like:

DELETE FROM some_table WHERE some_id IN (x1, x2, ..., xN)

You can't do joins in DELETE statements.

Tim
Thread
how many args to SELECT...IN()Joel Bremson6 Aug
Re: how many args to SELECT...IN()Paradox6 Aug
  • Re: how many args to SELECT...IN()Thimble Smith6 Aug
Re: how many args to SELECT...IN()Paradox6 Aug
  • Re: how many args to SELECT...IN()Joel Bremson6 Aug
    • Problem reading tablesPaul McGovern6 Aug
    • Re: how many args to SELECT...IN()Thimble Smith6 Aug
      • Re: how many args to SELECT...IN()Alok K. Dhir6 Aug
        • Re: how many args to SELECT...IN()Paradox6 Aug
          • Re: how many args to SELECT...IN()Michael Widenius6 Aug
        • Re: how many args to SELECT...IN()Christian Mack6 Aug
  • Re: how many args to SELECT...IN()Scott Hess6 Aug
    • Re: how many args to SELECT...IN()Joel Bremson6 Aug