UC知道数据库程序问题
来源：百度知道 编辑：UC知道 时间：2024/06/16 13:10:37
select pro_id,pro_name,pro_spec,pro_city,sum(psl_qty),sum(psl_qty)*(psl_prc2-psl_prc1) '让利金额'
from pos.p_sale inner join pos.product on pro_id = psl_pro_id
where psl_br_id = '0104' and
psl_prc1 <> psl_prc2 and
psl_date between '2007/01/01' and '2007/01/10'
group by pro_id,pro_name,pro_spec,pro_city;
from pos.p_sale inner join pos.product on pro_id = psl_pro_id
where psl_br_id = '0104' and
psl_prc1 <> psl_prc2 and
psl_date between '2007/01/01' and '2007/01/10'
group by pro_id,pro_name,pro_spec,pro_city;
select pro_id,pro-name,pro-spec,pro-city,sum(psi_pty),sum(psi_qty)*(psi_prc2-psi_prc1) as '让利金额'
from pos.p_sale inner join pos.product
on pro_id = psl_pro_id
where psl_br_id = '0104' and
psl_prc1 <> psl_prc2 and
psl_date between '2007/01/01' and '2007/01/10'
group by pro_id,pro_name,pro_spec,pro_city;
不行就用相关子查询
from子句引用一个包括聚和函数的子查询