join table delete result msyql query

DELETE  FROM `node_revisions`
WHERE   vid IN (
            SELECT  vid
            FROM    node
            WHERE   type = 'features_test'
        )