＋设为首页 ＋添加到收藏夹
select min_reg,
max_reg,
out_amt = isnull(sum(out_amt),0),
out_usd = isnull(sum(out_usd),0),
charge = isnull(sum(charge),0),
charge_count = isnull(sum(charge_count),0),
amt_count = isnull(sum(amt_count),0),
usd_count = isnull(sum(usd_count),0),
pro_amt = isnull(sum(pro_amt),0),
pro_usd = isnull(sum(pro_usd),0),
pro_amt_count = isnull(sum(pro_amt_count),0),
pro_usd_count = isnull(sum(pro_usd_count),0)
from (
select min_reg,/*类别*/
max_reg,/*大类*/
out_amt = THIRD_AMT,/*本日出货数量M2*/
out_usd = USD_VALUE,/*本日出货USD*/
charge = charge_row,/*本日运费*/
charge_count = 0,/*charge_count累计运费*/
amt_count = 0,/*amt_count累计出货数量*/
usd_count = 0,/*usd_count累计出货USD*/
pro_amt = 0 ,/*pro_amt本日下单m2*/
pro_usd = 0,/*pro_USD本日下单USD*/
pro_amt_count = 0,/*pro_amt_count累计下单AMT*/
pro_usd_count = 0/*pro_USD_count累计下单USD*/
from v_delivery_dayreport
where date = 2005-08-03 and sale_class = 2
union all
select min_reg,/*类别*/
max_reg,/*大类*/
out_amt = THIRD_AMT,/*本日出货数量M2*/
out_usd = USD_VALUE,/*本日出货USD*/
charge = charge_row,/*本日运费*/
charge_count = 0,/*charge_count累计运费*/
amt_count = 0,/*amt_count累计出货数量*/
usd_count = 0,/*usd_count累计出货USD*/
pro_amt = 0 ,/*pro_amt本日下单m2*/
pro_usd = 0,/*pro_USD本日下单USD*/
pro_amt_count = 0,/*pro_amt_count累计下单AMT*/
pro_usd_count = 0/*pro_USD_count累计下单USD*/
from v_delivery_dayreport
where date = 2005-08-03 and sale_class = 2
) as aa
group by min_reg,max_reg
服务器: 消息 301，级别 16，状态 2，行 1
查询中包含不允许的外联接请求。
直接用from()中的语句是没错的!
帮顶。
帮UP
不了解
不 group by ,直接 select * from (...)aa 呢?
