[sqlite] Re: delete/update joins

[Igor Tandetnik]

Joe Wilson <developir-/[EMAIL PROTECTED]> wrote:

This may be better:

delete from table1 where rowid in (
 select table1.rowid
   from table2
  where table1.id = table2.id
    and table2.otherid = 1
);

Why not just

delete from table1 where id in (
 select id from table2
  where table2.otherid = 1
);

Igor Tandetnik

-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------