Re: [sqlite] Re: store result

2006-01-19 Thread Dennis Cote
Igor Tandetnik wrote: Dennis Cote wrote: But I have to wonder why you suggest creating the temp table at all when this does the same thing: delete from source_table where id in (select id from source_table where some_condition = true); Or even delete from source_table where

[sqlite] Re: store result

2006-01-19 Thread Igor Tandetnik
Dennis Cote wrote: But I have to wonder why you suggest creating the temp table at all when this does the same thing: delete from source_table where id in (select id from source_table where some_condition = true); Or even delete from source_table where some_condition = true;