SELECT "CODE', "GUBOON",  -->    SELECT SALE."CODE', SALE."GUBOON",

  GROUP BY "CODE","GUBOON" -->   GROUP BY SALE."CODE", SALE."GUBOON"

실행해보진 않았지만  이 필드 앞에 테이블명을 명시해보세요.


델사랑 님이 쓰신 글 :
: 아래 SQL명령이 IBExpert와 Delphi 7에서는  문제없이 실행되는데
: Delphi 2007 Win 32 + dbExpress의  TSQLQuery 또는 TSQLDataSet에서
: "..... Token unknown  - line 13,  column 19  ?."  라는 Error 메세지가 뜹니다.
:  환장하겠습니다.
: 무슨 문제인지 살펴주십시오.
:
: SELECT X.*, D."AAA"
: FROM
: (
:   SELECT "CODE', "GUBOON",
:    SUM(IIF("PAY_GB"=1 AND "SER_NO">0,      1,   0)) AS "A",
:    SUM(IIF("PAY_GB"=1 AND "SER_NO">0, "AMT", 0)) AS "B",
:    SUM(IIF("PAY_GB"=1 AND "SER_NO"<0,      1,   0)) AS "C",
:    SUM(IIF("PAY_GB"=1 AND "SER_NO"<0, "AMT", 0)) AS "D",
:    SUM(IIF("PAY_GB"=0 AND "SER_NO">0,      1,   0)) AS "E",
:    SUM(IIF("PAY_GB"=0 AND "SER_NO">0, "AMT", 0)) AS "F",
:    SUM(IIF("SER_NO" < 0,                                1,  0)) AS "G",
:    SUM(IIF("SER_NO" < 0,                         "AMT",  0)) AS "H",
:    SUM(IIF("R_DATE" > "S_DATE",             "AMT",  0)) AS "K",
:    SUM(IIF("SER_NO"<0 AND "R_DATE" > "S_DATE", "AMT",  0)) AS "L"
:   FROM "SALE"
:   WHERE ("S_DATE" = :pDate) AND ("DAM" = :pDam)
:   GROUP BY "CODE", "GUBOON"
: ) X
: LEFT JOIN "CUSTOM" D ON D."CODE" = X."CODE"