How to Delete Table with Join Statement

Similar to my previous post on how to update with multiple join statements, this time, I need to delete rows in a table, but with extra criteria which made me need to join the table before deleting the rows.

To do this, there are several ways, however, I found this method is the easiest:

DELETE A FROM TABLE1 A
LEFT JOIN TABLE2 B ON A.ROWID = B.ROWID
WHERE A.first_name = 'James' AND B.last_name = 'Bond'

Comments

Popular posts from this blog

Black border on video created by Windows Live Movie Maker

Enable PHP opcache extension on Windows XAMPP

Error code 8024001b (solved)