delete a,b from t_account a,t_resource b where 1=1 and a.account_id=b.resource_id and a.account_id = '10'