Re: how many args to SELECT...IN()

[Thimble Smith]

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