Skip to main content
Ben Nadel
On User Experience (UX) Design, JavaScript, ColdFusion, Node.js, Life, and Love.

Rob Phillips

Member since Nov 18, 2009

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 »