有个这样的SQL语句
SELECT inv_view.list_no,
inv_view.cli_no,
inv_view.inv_date,
inv_view.prod_no,
inv_view.prod_add,
inv_view.batch_no,
inv_view.inv_num,
back_view.back_num,
inv_view.sell_price,
inv_view.dep_price,
inv_view.buy_price,
inv_view.retail_price,
inv_view.ts_bz
FROM inv_view left join back_view on inv_view.list_no=back_view.list_no查询结果2006030318002 014 2006-03-03 00:00:00.000 10180001 江苏晨牌 050515 2.000 2.000 120.00 60.632479 70.94 138.00 3
2006030403016 014 2006-03-04 00:00:00.000 43907030 上海八通 20060104 24.000 NULL 11.30 7.692308 4.60 13.00 3
2006030603000 013 2006-03-06 00:00:00.000 20570100 广州白云山 1050242 10.000 NULL 3.90 2.905983 3.90 4.49 3
2006030603000 013 2006-03-06 00:00:00.000 20913200 云南盘龙云海 051251 1.000 NULL 52.17 40.427350 56.50 60.00 3
2006030603001 011 2006-03-06 00:00:00.000 21360100 桂林三金 0601069 3.000 NULL 8.69 6.059829 10.40 9.99 3中间那里BACK_NUM那里有NULL的 我想把它变为0,请问怎样做
SELECT inv_view.list_no,
inv_view.cli_no,
inv_view.inv_date,
inv_view.prod_no,
inv_view.prod_add,
inv_view.batch_no,
inv_view.inv_num,
back_view.back_num,
inv_view.sell_price,
inv_view.dep_price,
inv_view.buy_price,
inv_view.retail_price,
inv_view.ts_bz
FROM inv_view left join back_view on inv_view.list_no=back_view.list_no查询结果2006030318002 014 2006-03-03 00:00:00.000 10180001 江苏晨牌 050515 2.000 2.000 120.00 60.632479 70.94 138.00 3
2006030403016 014 2006-03-04 00:00:00.000 43907030 上海八通 20060104 24.000 NULL 11.30 7.692308 4.60 13.00 3
2006030603000 013 2006-03-06 00:00:00.000 20570100 广州白云山 1050242 10.000 NULL 3.90 2.905983 3.90 4.49 3
2006030603000 013 2006-03-06 00:00:00.000 20913200 云南盘龙云海 051251 1.000 NULL 52.17 40.427350 56.50 60.00 3
2006030603001 011 2006-03-06 00:00:00.000 21360100 桂林三金 0601069 3.000 NULL 8.69 6.059829 10.40 9.99 3中间那里BACK_NUM那里有NULL的 我想把它变为0,请问怎样做
SELECT inv_view.list_no,
inv_view.cli_no,
inv_view.inv_date,
inv_view.prod_no,
inv_view.prod_add,
inv_view.batch_no,
inv_view.inv_num,
isnull(back_view.back_num,0),
inv_view.sell_price,
inv_view.dep_price,
inv_view.buy_price,
inv_view.retail_price,
inv_view.ts_bz
FROM inv_view left join back_view on inv_view.list_no=back_view.list_no
或者
coalesce(BACK_NUM,0)
inv_view.cli_no,
inv_view.inv_date,
inv_view.prod_no,
inv_view.prod_add,
inv_view.batch_no,
inv_view.inv_num,
isnull( back_view.back_num,0) as back_num,
inv_view.sell_price,
inv_view.dep_price,
inv_view.buy_price,
inv_view.retail_price,
inv_view.ts_bz
FROM inv_view left join back_view on inv_view.list_no=back_view.list_no
from tb