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

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

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

望高手解答