Rob Phillips
Member since Nov 18, 2009
- Profile: /members/4789-rob-phillips.htm
- Comments: 1
Recent Blog Comments By Rob Phillips
-
Using A SQL JOIN In A SQL DELETE Statement (Thanks Pinal Dave!)
Posted on Nov 18, 2009 at 7:01 AM
Thank you! This was very helpful. I needed to delete from a joining table with a two-field primary key so I couldn't use my normal method since there was no single unique field: DELETE FROM table WHERE field IN (SELECT...) Instead I used: DELETE J FROM Users U inner join LinkingTable J ... read more »