Check out example codes for "mysql #1093 - You can't specify target table error". It will help you in understanding the concepts better.

Code Example 1

DELETE FROM story_category
WHERE category_id NOT IN (
    SELECT cid FROM (
        SELECT DISTINCT category.id AS cid FROM category 
        INNER JOIN story_category ON category_id=category.id
    ) AS c
)

Learn ReactJs, React Native from akashmittal.com