select 取引先コード as 請求先コード, max(得意先名) as 請求先名, sum(金額) as 請求金額 from V_得意先台帳 where 取引日付 between #2005/06/19# and #2005/07/20# group by 取引先コード
select 取引先コード as 請求先コード, max(得意先名) as 請求先名, sum(金額) as 請求金額 from V_得意先台帳 where 取引日付 between '2005/06/19' and '2005/07/20' group by 取引先コード
select 取引先コード as 請求先コード, max(得意先名) as 請求先名, sum(金額) as 請求金額 from "V_得意先台帳" where 取引日付 between '2005/06/19' and '2005/07/20' group by 取引先コード