Select Buyerno, Exportno from T_ecmybuyerInfo Group by Buyerno, Exportno Having Count (*)> 1
Delete from t_ecmybuyerinfo where buyerno = 'KOR / 098940' and Buyerkey = '149426'select BuyernoApply, Buyerno, Policyno from t_declaredetail where buyerno =' GBR / 055381 '
Select * from t_ecmybuyerinfo where buyerno = 'usa / 031888'
Select BuynoApply, Buyerno, Policyno from T_QuotaApply where t_quotaapply.buynoApply = '151869'select * from t_declaredetail where buyernoApply =' 149426'update
/ * Formatted on 2004/12/26 12:03 (RevealNet Formatter v4.4.0) * / UPDATE T_DECLAREDETAIL a SET a.buyernoapply = (SELECT b.buyerkey FROM T_ECMYBUYERINFO b, T_BCROPIDWEBAPPROVE c, T_SPOLICY d WHERE a.buyerno = b. buyerno AND d.insurantno = c.EXPORTNO AND d.policyno = a.policyno AND b.exportno = c.CORPAPPLYID AND b.exportno IS NOT NULL) WHERE EXISTS (SELECT 1 FROM T_ECMYBUYERINFO b WHERE a.buyerno = b.buyerno)
SELECT corpapplyid FROM T_BCROPIDWEBAPPROVE a, T_SPOLICY b WHERE a.EXPORTNO = b.INSURANTNO AND b.POLICYNO = '1200EC19980045'SELECT DISTINCT (b.buyerkey) FROM T_DECLAREDETAIL a, T_ECMYBUYERINFO b, T_BCROPIDWEBAPPROVE c, T_SPOLICY d WHERE a.buyerno = b. Buyerno and c.Exportno = D.insurantno and d.policyno = a.policyno and a.policyno = 'CH000271-040400' Selectc.buyerkey, A.Buyerno, B.Buyerno, C.Buyerno, B.Engname, C.Engname , c.Exportno from t_declaredetail a, t_buyerinfo b, t_ecmybuyerinfo cwhere a.buyerno = B.Buyerno and A.BuyernoApply = C.BuyerKeyand B.Engname <> c.EngnameCommit
