Re: Advanced delete SQL syntax

2001-02-19 Thread Rolf Hopkins
If it is, someone please let me know where as it is definitely not under 7.17 of the manual. - Original Message - From: "Øystein Selbekk" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, February 20, 2001 3:21 Subject: Advanced delete SQL syntax > Doe

Advanced delete SQL syntax

2001-02-19 Thread Øystein Selbekk
Does anyone know the syntax for deleting records based on a join? This is what i do in Sybase ASE: delete table1 from table1,table2 where table1.somecol=table2.somecol and table2.somecol2=somevalue and table1.somecol4=someothervalue Anyone got a clue? Thanks! regards Oystein Selbekk, Visbook