P00481708010002 18 18
P00481708010002 20 20
根據的 P00481708010002 單號 上面的原始資料
最后變成
P00481708010002 38 38
P00481708010002 38 38
要保證兩條資料還存在 不能整合為一條資料！！！！！！只是金額發生變化 都變成38
原始代碼
SELECT cyhq_u_orderdish.ch_branchno as '店名', --店名
t_hq_branch_info.vch_company,
--(select t_hq_branch_info.vch_company from t_hq_branch_info) as '店名',
cyhq_u_orderdish.ch_payno as '結算單號' ,
cyhq_u_orderdish.ch_billno as '開單號' , --開單號
cyhq_u_orderdish.ch_dishno as '品碼', --品碼
(SELECT vch_dishname FROM cybr_bt_dish WHERE ch_dishno = cyhq_u_orderdish.ch_dishno) as '品名', --品名 cyhq_u_orderdish.num_price_org -(convert(decimal(10,2),cyhq_u_orderdish.num_price_org+num_price_add- (cyhq_u_orderdish.int_discount*1.0/100*(cyhq_u_orderdish.num_price_org+num_price_add)))) as '實際金額' , cyhq_u_orderdish.num_price_org as '銷售金額' ,
convert(decimal(10,2),cyhq_u_orderdish.num_price_org+num_price_add- (cyhq_u_orderdish.int_discount*1.0/100*(cyhq_u_orderdish.num_price_org+num_price_add))) as '折扣金額' ,
cyhq_u_orderdish.num_price_add as '加價'
from cyhq_u_orderdish left join t_hq_branch_info on t_hq_branch_info.ch_branchno = cyhq_u_orderdish.ch_branchno
where cyhq_u_orderdish.ch_payno='P00481708010002'
其中 cyhq_u_orderdish.ch_payno 是P00481708010002 cyhq_u_orderdish.num_price_org是第一行18 第二行20
uj5u.com熱心網友回復：
是列之間相加嗎？select 欄位1+欄位2 as 欄位1,欄位2+欄位1 as 欄位2 from 表
uj5u.com熱心網友回復：
是上下累加。。不是橫向uj5u.com熱心網友回復：
col1, col2, col3P00481708010002,18,18
P00481708010002,20,20
select table1.col1, v.col2,v.col3
from table1 inner join (select col1,sum(col2) as c2,sum(col3) as c3 from table1 group by col1) v on table1.col1=v.col1
uj5u.com熱心網友回復：
xiazisr結帖率：0%
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/116656.html
標籤：MySQL
上一篇：財智軟體資料庫打不開
下一篇：關聯兩個資料庫查詢問題