通过二表关联的查询到数据如何删除（oracle）

Question

select * from ETL_KJ inner join ETL_DEAL_LOG on ETL_KJ.KJID=ETL_DEAL_LOG.SOURCEID

这是我查询的语句

---

delete ETL_KJ,ETL_DEAL_LOG from ETL_KJ left join ETL_DEAL_LOG on ETL_KJ.KJID =ETL_DEAL_LOG.SOURCEID where ETL_KJ.KJID=ETL_DEAL_LOG.SOURCEID

这是我写的关联删除语句，但是报错

望高手解答

Answer 1

写法有问题，不能这样写，需要一个子查询
另外，delete是删除记录，不是删除字段，这里看你写法你好像并不太清楚这个
delete from tableA where tableA.id in (select tableA.id from tableA join tableB on tableA.id=tableB.id)