--- garry saddington <garry@schoolteachers.co.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