Re: SQL: looking for "IN (SELECT blabla FROM blablaTable)" in MySQL

[Paul DuBois]

At 4:55 PM -0800 2000-01-15, Raffael Heinzer wrote:
>Grüezi,
>   I'd like to delete some records in the common SQL way in MySQL:
>"DELETE FROM [table] WHERE [i] IN (SELECT [u] FROM [anotherTable] WHERE
>...)"
>
>I figured out that "IN (12, 13, 14)" with a list of constants works -
>but I need to have there something dynamically... :(
>
>Is there any way of doing that in a different way in MySQL (or is my
>statement incorrect?) or do I have to put that logic into the DBClient?


You must put the logic in your client.

-- 
Paul DuBois, paul@stripped