删除一张表在另外一张表的相同数据

DELETE from qx_t_user1  WHERE userid in (

SELECT t.userid from

(select b.* from qx_t_user1 b

where b.userid in (select userid from qx_t_user)  )AS t )