相关SQL

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