weixin_43780980
李易峰不是我
2019-04-26 11:01

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

  • oracle
  • sql

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

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

望高手解答

  • 点赞
  • 回答
  • 收藏
  • 复制链接分享

1条回答