Re: [GENERAL] delete with self join

2007-04-17 Thread garry saddington
On Tue, 2007-04-17 at 10:15 +0100, Richard Huxton wrote: > garry saddington wrote: > > On Tue, 2007-04-17 at 09:21 +0100, Richard Huxton wrote: > >> garry saddington wrote: > >>> I am trying this syntax which is my interpretation of the docs: > >>> > >>> delete from siblings s1 using siblings

Re: [GENERAL] delete with self join

2007-04-17 Thread Richard Huxton
garry saddington wrote: On Tue, 2007-04-17 at 09:21 +0100, Richard Huxton wrote: garry saddington 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 C

Re: [GENERAL] delete with self join

2007-04-17 Thread Thomas Burdairon
On Apr 17, 2007, at 11:07, garry saddington wrote: I am keeping a record of siblings in a school. The user chooses one student and there siblings such that id's are entered into a table as such: TABLE SIBLINGS: principal sibling 809 234 809 785 809 345 809

Re: [GENERAL] delete with self join

2007-04-17 Thread garry saddington
On Tue, 2007-04-17 at 09:21 +0100, Richard Huxton wrote: > garry saddington 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 > > > >

Re: [GENERAL] delete with self join

2007-04-17 Thread Richard Huxton
garry saddington 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? 1. What's happening - are you getting a

Re: [GENERAL] delete with self join

2007-04-16 Thread Richard Broersma Jr
--- garry saddington <[EMAIL PROTECTED]> 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? Wh

[GENERAL] delete with self join

2007-04-16 Thread garry saddington
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? regards Garry ---(end of broadcast)--