이렇게 두개의 쿼리를 넣었거든여..
근데 위에 있는 쿼리와 아래의 쿼리가 무슨차이가 있는지..
deliv_qty,deliv_amt,surtax,tot_amt가 숫자인데..
위에껀...천단위 컴마가 찍히거든여..
근데 아래껀..천단위 컴마가 안찍혀여..
차이를 모르겟어여..
DBGRID를 써서 연결했는데..
같은 dbgrid를 써서..바꿔주기만 하거덩여 차이를 알려 주세여..


------------------------------------------------------
select m.vend_cd vend_cd
      ,v.vend_nm vend_nm
      ,sum(nvl(d.deliv_qty,0)) deliv_qty   -숫자
      ,sum(nvl(d.deliv_amt,0)) deliv_amt -숫자
      ,sum(nvl(d.surtax,0)) surtax  -숫자                    
      ,sum(nvl(d.deliv_amt,0) + nvl(d.surtax,0)) tot_amt -숫자
      ,z.cd_name cd_name                                
from t_bbm10 m, t_bbd10 d, t_zam10 z, t_zdm10 v          
where m.deliv_no = d.deliv_no                            
  and m.vend_cd = v.vend_cd                              
  and z.gbn = '3000'and m.cargo_no = z.code                        
and m.input_date between :st and :en
  
group by v.vend_nm, m.vend_cd, z.cd_name                
------------------------------------------------------
select
      d.code code  
      ,v.cd_name cd_name
      ,sum(nvl(d.DELIV_QTY,0)) DELIV_QTY -숫자
      ,sum(nvl(d.deliv_amt,0)) deliv_amt -숫자
      ,sum(nvl(d.surtax,0)) surtax -숫자
      ,sum(nvl(d.deliv_amt,0) + nvl(d.surtax,0)) tot_amt -숫자
      ,z.cd_name cd_name
from  t_bbm10 m, t_bbd10 d, t_zam10 v, t_zam10 z
where m.deliv_no = d.deliv_no                              
  and v.gbn = '8000'and d.code = v.code                  
  and z.gbn = '3000'and m.cargo_no = z.code    
and m.input_date between :st and :en                                                  

group by v.cd_name, d.code, z.cd_name
------------------------------------------------------