--- Igor Tandetnik <[EMAIL PROTECTED]> wrote:
> Joe Wilson wrote:
> > 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
Joe Wilson 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
--
2 matches
Mail list logo