This may be better:
delete from table1 where rowid in (
select table1.rowid
from table2
where table1.id = table2.id
and table2.otherid = 1
);
--- Joe Wilson <[EMAIL PROTECTED]> wrote:
> How about:
>
> delete from table1 where id in (
>select table1.id
> from table1,
How about:
delete from table1 where id in (
select table1.id
from table1, table2
where table1.id = table2.id
and table2.otherid = 1
);
or this:
delete from table1 where rowid in (
select table1.rowid
from table1, table2
where table1.id = table2.id
and
Are there any plans to support joins on delete? it can get quite long to
do it the manual way when you have a lot of relational data.
DELETE FROM table
INNER JOIN table2
ON table.id = table2.id
WHERE table2.otherid = 1
This works in standard sql, I realise it may be difficult to implement
just
3 matches
Mail list logo