I want to remove all unsubscribed accounts from Mysql accounts table. The unsubscribed user accounts are all available in another table(subscribed accounts). I want Mysql to take all the accounts from the unsubscribed table and remove it from the subscribed accounts table. How do I achieve this? Can anyone please help?