파라독스7 사용하고요


        DatabaseName:='Happy';
        close;
SQL.clear;
SQL.ADD('select C_Name,Tel,(Addr_dong+Addr_bungi+Addr_Hosu+Addr_bild) as addr,
                           sum(ea) as TEA,sum(Chulgo) as TCO,sum (AMOUNTT_A+AMOUNT_B  
                           +AMOUNT_C)    as TAM,sum(Sukeum) as TS, sum(AMOUNT_DRY+
                             AMOUNT_SUSUN+AMOUNT_WATER-Sukeum) as TJAN');
SQL.ADD('from familly,Yeongsu ,Custom');
SQL.ADD('Where Yeongsu.EA = Yeongsu.Chulgo and (Yeongsu.AMOUNT_DRY
                 +Yeongsu.AMOUNT_SUSUN+Yeongsu.AMOUNT_WATER) > Yeongsu.sukeum
                  and (Yeongsu.C_Num = Custom.C_Num and Custom.C_Num = Familly.C_Num
                  and Familly.C_Num1 = :A)');
SQL.ADD('group by Tel,C_NAME');//,Addr_dong,Addr_bungi,Addr_Hosu,Addr_bild
  SQL.ADD('ORDER BY C_NAME,Tel');
   ParamByName('A').asstring:= '0';
   if Prepared = false then Prepare;
    MainF.Query1.open;
    end;

select 절에(Addr_dong+Addr_bungi+Addr_Hosu+Addr_bild) as addr 때문에 Group By가 안되네요
이유가 뭘까요?  CalcField를 사용치 않고 문자필드를 합하고 싶은데....
아님 필드를 하나로 만들고 동,번지,호수,건물명을 검색하는 방법이 있나요?

이상 초보의 질문 이었습니다.
고견 부탁드립니다