USE T24M001

USE COMMON

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














USE COMMON

DELETE FROM ACCOUNT_MASTER WHERE ACCNAME='R.K TRADING' OR ACCNAME='SHIV SHAKTI SAREE CENTER'
DELETE FROM AGENT_MASTER WHERE (AGENTNAME='R.K TRADING' OR AGENTNAME='SHIV SHAKTI SAREE CENTER' ) AND AGENTCODE NOT IN (SELECT ACCAGENTCODE FROM ACCOUNT_MASTER)

--------------------AGENT USE IN BILL DETAIL
USE T27K001

DELETE FROM ACCOUNT_MASTER WHERE ACCNAME='R.K TRADING' OR ACCNAME='SHIV SHAKTI SAREE CENTER'
DELETE FROM AGENT_MASTER WHERE (AGENTNAME='R.K TRADING' OR AGENTNAME='SHIV SHAKTI SAREE CENTER') AND AGENTCODE NOT IN (SELECT ACCAGENTCODE FROM ACCOUNT_MASTER) AND AGENTCODE NOT IN (SELECT AGENTCODE FROM BILL_DETAIL)

SELECT * FROM AGENT_MASTER WHERE AGENTNAME='R.K TRADING' OR AGENTNAME='SHIV SHAKTI SAREE CENTER' 
SELECT * FROM AGENT_MASTER