table - MySQL error 1093. how to delete from this -

select worked:

select * a.id not in  ( select id inner join b b (a.`name` = b.`name`    , a.`status` = b.`description`)) 

delete doesn't work:

delete pre_log  pre_log.id not in  ( select id pre_log p inner join sobg_table s (p.`name` = s.`name`    , p.`status` = s.`description`) ) 

error code: 1093. can't specify target table 'pre_log' update in clause 0,001 sec

you have specified pre_log table in sub query delete records

try might you..

delete l.* pre_log l l.id not in  ( select id     (    select id pre_log p        inner join sobg_table s     (p.`name` = s.`name`        , p.`status` = s.`description`)     ) x     )