ringa_lee
delete deletes the actual table, while the result of the join query (join) is a "temporary table". If you want to do it all at once, you need to use a subquery: delete from xxx where xx in (select...)
![[Web front-end] Node.js quick start](https://img.php.cn/upload/course/000/000/067/662b5d34ba7c0227.png)
delete deletes the actual table, while the result of the join query (join) is a "temporary table". If you want to do it all at once, you need to use a subquery: delete from xxx where xx in (select...)