osql -S %1 -U ct21user -P ct21 -d %2 -Q "DELETE FROM ctgTradeParamT WHERE PracticeCode IN (SELECT ctgTradeParamT.PracticeCode FROM  ctgTradeParamT FULL OUTER JOIN ctpPracticeM ON ctgTradeParamT.PracticeCode = ctpPracticeM.PracticeCode WHERE (ctpPracticeM.PracticeCode IS NULL))"

osql -S %1 -U ct21user -P ct21 -d %2 -Q "DELETE FROM ctpTownT WHERE PracticeCode IN (SELECT ctpTownT.PracticeCode FROM  ctpTownT FULL OUTER JOIN ctpPracticeM ON ctpTownT.PracticeCode = ctpPracticeM.PracticeCode WHERE (ctpPracticeM.PracticeCode IS NULL))"

osql -S %1 -U ct21user -P ct21 -d %2 -Q "DELETE FROM cthPTenantM WHERE PracticeCode IN (SELECT cthPTenantM.PracticeCode FROM  cthPTenantM FULL OUTER JOIN ctpPracticeM ON cthPTenantM.PracticeCode = ctpPracticeM.PracticeCode WHERE (ctpPracticeM.PracticeCode IS NULL))"

osql -S %1 -U ct21user -P ct21 -d %2 -Q "DELETE FROM ctdItemM WHERE PracticeCode IN (SELECT ctdItemM.PracticeCode FROM  ctdItemM FULL OUTER JOIN ctpPracticeM ON ctdItemM.PracticeCode = ctpPracticeM.PracticeCode WHERE (ctpPracticeM.PracticeCode IS NULL))"

osql -S %1 -U ct21user -P ct21 -d %2 -Q "DELETE FROM cttStockM WHERE PracticeCode IN (SELECT cttStockM.PracticeCode FROM  cttStockM FULL OUTER JOIN ctpPracticeM ON cttStockM.PracticeCode = ctpPracticeM.PracticeCode WHERE (ctpPracticeM.PracticeCode IS NULL))"

osql -S %1 -U ct21user -P ct21 -d %2 -Q "DELETE FROM ctnQandAM WHERE PracticeCode IN (SELECT ctnQandAM.PracticeCode FROM  ctnQandAM FULL OUTER JOIN ctpPracticeM ON ctnQandAM.PracticeCode = ctpPracticeM.PracticeCode WHERE (ctpPracticeM.PracticeCode IS NULL))"