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'
SELECT
c.buyerkey,a.buyerno,b.buyerno,c.buyerno,b.engname,c.engname,c.exportno
FROM T_DECLAREDETAIL A,T_BUYERINFO B,T_ECMYBUYERINFO C
WHERE a.buyerno=b.buyerno AND a.BUYERNOAPPLY=c.buyerkey
AND b.engname<>c.engname
COMMIT