--- garry saddington <garry@xxxxxxxxxxxxxxxxxxxx> 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
