ÈçºÎ°ÑÕâ¾äsqlÓï¾äת»¯Îªaccess¿ÉÓõģ¿

SQL code:

select CUSTOMER_ID,CUSTOMER_NAME,CUSTOMER_ADDRESS,BUY_TIME,BUY_TIMES,WRITE_TIMES,sum(CARD_EN) as CARD_EN,sum(BUY_MONEY) as BUY_MONEY,sum(BC_YSJE) as BC_YSJE,sum(SUM_USE) as SUM_USE,sum(REMAIN_EN) as REMAIN_EN,convert(varchar(10),BUY_TIME,120) as date from T_BUT_RECORD
group by CUSTOMER_ID,CUSTOMER_NAME,CUSTOMER_ADDRESS,BUY_TIME,BUY_TIMES,WRITE_TIMES,convert(varchar(10),BUY_TIME,120)
union all
select CUSTOMER_ID,CUSTOMER_NAME,CUSTOMER_ADDRESS,BUY_TIME,BUY_TIMES,WRITE_TIMES,
sum(BUY_MONEY) as BUY_MONEY,sum(BC_YSJE) as BC_YSJE,sum(SUM_USE) as SUM_USE,sum(REMAIN_EN) as REMAIN_EN,
convert(varchar(10),getdate(),120)
from T_BUT_RECORD
group by CUSTOMER_ID,CUSTOMER_NAME,CUSTOMER_ADDRESS,BUY_TIME,BUY_TIMES,WRITE_TIMES

---

accessÓï·¨²»ÊìϤ£¬°ï¶¥··

---

select CUSTOMER_ID,CUSTOMER_NAME,CUSTOMER_ADDRESS,BUY_TIME,BUY_TIMES,WRITE_TIMES,sum(CARD_EN) as CARD_EN,sum(BUY_MONEY) as BUY_MONEY,sum(BC_YSJE) as BC_YSJE,sum(SUM_USE) as SUM_USE,sum(REMAIN_EN) as REMAIN_EN,convert(varchar(10),BUY_TIME,120) as 'date' from T_BUT_RECORD
group by CUSTOMER_ID,CUSTOMER_NAME,CUSTOMER_ADDRESS,BUY_TIME,BUY_TIMES,WRITE_TIMES,convert(varchar(10),BUY_TIME,120)
union all
select CUSTOMER_ID,CUSTOMER_NAME,CUSTOMER_ADDRESS,BUY_TIME,BUY_TIMES,WRITE_TIMES,
sum(BUY_MONEY) as BUY_MONEY,sum(BC_YSJE) as BC_YSJE,sum(SUM_USE) as SUM_USE