2023年2月4日
为若依逆向工程创建mysql视图
摘要： create view view_jin_xiao_cun2 as SELECT a.jiezhuan_prod_code as prod_code,a.jiezhuan_prod_name as prod_name, IFNULL(b.jiezhuan_count,0) as qichu_coun 阅读全文
posted @ 2023-02-04 17:04 依云科技 阅读(88) 评论(0) 推荐(0)
进销存三表联合查询
摘要： SELECT a.jiezhuan_prod_code as 商品代码,a.jiezhuan_prod_name as 商品名称, IFNULL(b.jiezhuan_count,0) as 期初数量,IFNULL(b.jiezhuan_money,0) as 期初金额, IFNULL(c.入库数量 阅读全文
posted @ 2023-02-04 14:09 依云科技 阅读(42) 评论(0) 推荐(0)