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'