---RUN IN ALL FIRM
USE T25S001

USE COMMON

DELETE FROM ACCOUNT_MASTER WHERE ACCNAME='BABLU BHAI SHARMA' 
DELETE FROM AGENT_MASTER WHERE AGENTNAME='BABLU BHAI SHARMA' AND AGENTCODE NOT IN (SELECT ACCAGENTCODE FROM ACCOUNT_MASTER)


DELETE FROM ACCOUNT_MASTER WHERE ACCNAME='LOVE' 
DELETE FROM AGENT_MASTER WHERE AGENTNAME='LOVE' AND AGENTCODE NOT IN (SELECT ACCAGENTCODE FROM ACCOUNT_MASTER)









LOVE