Re: delete with self join

[Richard Broersma Jr <rabroersma(at)yahoo(dot)com>]

--- garry saddington <garry(at)schoolteachers(dot)co(dot)uk> wrote:

> I am trying this syntax which is my interpretation of the docs:
> 
>      delete from siblings s1 using siblings s2
>         WHERE  s1.principal = s2.principal
>               and s1.sibling=175
> 
> Can anyone tell me where I am going wrong?

What is your query do that is different that what you expect? However, I expect that your query
can effectively be reduced to:

delete from siblings where s1.sibling=175;

since "s1.principal = s1.principal" isn't really doing much reduce the number of rows for
deletion.

Regards,
Richard Broersma