Snippets
DZone Snippets is a public source code repository. Easily build up your personal collection of code snippets, categorize them with tags / keywords, and share them with the world

Snippets has posted 5883 posts at DZone. View Full User Profile

Delete Data From Table Using Inner Join

01.30.2012
| 3502 views |
  • submit to reddit 
        // delete data from table using inner join


DELETE table1 t1 FROM table1 INNER JOIN table2 t2 ON t1.key = t2.key WHERE t1.column1 = <condition>
"Starting from scratch" is seductive but disease ridden
-Pithy Advice for Programmers