delete from
(SELECT rf.*,u.userName,f.f_name FROM ROSE_FENPEI
rf LEFT JOIN funTb f
ON rf.F_ID=f.f_id
INNER JOIN userTb u ON rf.U_ID=u.u_id
WHERE f.fa_id = 3815 AND f.f_name='取消确认'))
where rf.LEN_ID in (9132210,8640728)
红色部分执行的结果:
然后想删除查询出来的结果中指定的记录,SQL语句怎么写?