随笔分类 -  视图函数存储

【视图】实时库存【SSKC】
摘要：select A.pluno,A.pluname,A.qty,CASE WHEN b.QTY IS NULL THEN 0 ELSE B.QTY END AS XSQTY ,case when c.tgqty is null then 0 else c.tgqty end as TGQTY,case... 阅读全文
posted @ 2014-08-07 22:32 nlg3413 阅读(392) 评论(0) 推荐(0)