SELECT NVL (r.bgoodsamount, 0) b_left_amount,
( NVL (k.pgoodsamount, 0)
+ NVL (pa.stationamount, 0)
+ NVL (pb.abamount, 0)
+ NVL (pc.inturnamount, 0)
- NVL (pd.abamount, 0)
- NVL (pe.sendamount, 0)
- NVL (pf.sendamount, 0)
- NVL (pg.sendamount, 0)
) r请问这个r是个什么值?是他们加减计算出的值吗?
b_left_amount又是什么值?
( NVL (k.pgoodsamount, 0)
+ NVL (pa.stationamount, 0)
+ NVL (pb.abamount, 0)
+ NVL (pc.inturnamount, 0)
- NVL (pd.abamount, 0)
- NVL (pe.sendamount, 0)
- NVL (pf.sendamount, 0)
- NVL (pg.sendamount, 0)
) r请问这个r是个什么值?是他们加减计算出的值吗?
b_left_amount又是什么值?
b_left_amount 是 NVL (r.bgoodsamount, 0) 的代称, r是那一长串的代称
b_left_amount 是 NVL (r.bgoodsamount, 0) 的别名
+ NVL (pa.stationamount, 0)
+ NVL (pb.abamount, 0)
+ NVL (pc.inturnamount, 0)
- NVL (pd.abamount, 0)
- NVL (pe.sendamount, 0)
- NVL (pf.sendamount, 0)
- NVL (pg.sendamount, 0)
你是说这一串算出来的结果附给r吗?