select * from c_deal where de_mb_id='admin' and de_t='5' and de_jo_name = (select de_jo_name FROM c_deal WHERE `de_mb_id` ='admin' AND `de_t` ='5' group by de_jo_name having sum(de_qtyB)-sum(de_qtyS) < 1 )
요러면 원하는 리스트 나오는데
요걸
delete from c_deal where de_mb_id='admin' and de_t='5' and de_jo_name = (select de_jo_name FROM c_deal WHERE `de_mb_id` ='admin' AND `de_t` ='5' group by de_jo_name having sum(de_qtyB)-sum(de_qtyS) < 1 )
하면
#1093 - You can't specify target table 'c_deal' for update in FROM clause 게 되는 이유 아시는분 ....
댓글을 작성하시려면 로그인이 필요합니다.
댓글 3개
체크해봐야 할 부분
1. delete 조건절에 subquery 가능 여부와 subquery 에 group by, having 가능 여부
- select 랑 delete랑 다를수 있음..
2. select 에 max를 써봄
3. de_jo_name = 을 de_jo_name in 조건으로 변경해봄
해당 서브쿼리를 한번 더 감싸주시면 됩니당..
DELETE from c_deal
WHERE de_mb_id='admin'
AND de_t='5'
AND de_jo_name = (select T1.de_jo_name
from ( select de_jo_name
from c_deal
where `de_mb_id` ='admin'
and `de_t` ='5'
group by de_jo_name
having sum(de_qtyB)-sum(de_qtyS) < 1) T1)
요런식으로...