Delete - I can't specify target table? While deleting using query

Question

DELETE FROM wp_posts 
WHERE ID > ( 
    SELECT ID 
    FROM wp_posts 
    WHERE post_title = 'angiegreen') 
        && (post_author = 0 
            OR post_author > ( 
                SELECT ID FROM `wp_users` WHERE user_login = 'angiegreen'));