急，这个SQL如何写？

Question

SELECT  a.HCKBCD,                                                                                
        TO_CHAR(a.SRSZGK),                                                                            
        z.VENDOR_NAME,                                                                                
        e.SISNNO,                                                                                    
        g.SYHNCD,                                                                                    
        c.SYHNNM,                                                                
        TO_CHAR(a.SRKHRK),                                                      
        TO_CHAR(a.SRSVRK),
        TO_CHAR(a.SRRKST),
        TO_CHAR(a.SRKYMD,'YYYY/MM/DD'),
        e.HCHUNO
FROM    HACCHU a,                                    
        APPS_TRHKMT z,                                 
        HCHUMS b,                                    
        SYHNMT c,                                    
        (select distinct SISNNO, HCHUNO from HCSRMS) e,                                    
        SHKTKR g                                    
WHERE    z.VENDOR_SITE_CODE(+) = a.HCTHCD                                  
AND        a.HCTHCD = a.HCTHCD                                
AND        a.HCKBCD = '6'                                                    
AND        a.HCHUNO = e.HCHUNO                                                   
AND        g.SISNNO = e.SISNNO

Answer 1

SELECT  a.HCKBCD,
        TO_CHAR(a.SRSZGK),
        z.VENDOR_NAME,
        e.SISNNO,
        g.SYHNCD,
        c.SYHNNM,
        TO_CHAR(a.SRKHRK),
        TO_CHAR(a.SRSVRK),
TO_CHAR(a.SRRKST),
        TO_CHAR(a.SRKYMD,'YYYY/MM/DD'),
        e.HCHUNO
FROM    HACCHU a,                                    
        APPS_TRHKMT z,
        HCHUMS b,
        SYHNMT c,
        (select distinct SISNNO, HCHUNO from HCSRMS) e,
        SHKTKR g
WHERE    z.VENDOR_SITE_CODE(+) = a.HCTHCD
AND        a.HCTHCD = a.HCTHCD
AND        a.HCKBCD = '6'
AND        a.HCHUNO = e.HCHUNO
AND        g.SISNNO = e.SISNNO

Answer 2

加个distinct 
SELECT  DISTINCT -- Here !a.HCKBCD,                                                                                    
        TO_CHAR(a.SRSZGK),                                                                            
        z.VENDOR_NAME,                                                                                
        e.SISNNO,                                                                                    
        g.SYHNCD,                                                                                    
        c.SYHNNM,                                                                
        TO_CHAR(a.SRKHRK),                                                      
        TO_CHAR(a.SRSVRK),
        TO_CHAR(a.SRRKST),
        TO_CHAR(a.SRKYMD,'YYYY/MM/DD'),
        e.HCHUNO
FROM    HACCHU a,                                    
        APPS_TRHKMT z,                                 
        HCHUMS b,                                    
        SYHNMT c,                                    
        HCSRMS e,                                    
        SHKTKR g                                    
WHERE    z.VENDOR_SITE_CODE(+) = a.HCTHCD                                  
AND        a.HCTHCD = a.HCTHCD                                
AND        a.HCKBCD = '6'                                                    
AND        a.HCHUNO = e.HCHUNO                                                   
AND        g.SISNNO = e.SISNNO