stock_blance_design_file_view创建

最新推荐文章于 2023-09-24 20:48:51 发布

YQG123456

最新推荐文章于 2023-09-24 20:48:51 发布

阅读量159

点赞数

分类专栏： sql经验文章标签： SQL

sql经验专栏收录该内容

10 篇文章

订阅专栏

本文介绍了一种通过 SQL 语句创建名为 stock_blance_design_file_view 的视图的方法。该视图整合了 design_file 和 stock_balance 表中的数据，以便于更高效地管理和查询产品库存信息。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >


CREATE  VIEW `stock_blance_design_file_view` AS select `s`.`id` AS `id`,`s`.`FIRST_KIND_ID` AS `FIRST_KIND_ID`,`s`.`FIRST_KIND_NAME` AS `FIRST_KIND_NAME`,`s`.`SECOND_KIND_ID` AS `SECOND_KIND_ID`,`s`.`SECOND_KIND_NAME` AS `SECOND_KIND_NAME`,`s`.`THIRD_KIND_ID` AS `THIRD_KIND_ID`,`s`.`THIRD_KIND_NAME` AS `THIRD_KIND_NAME`,`s`.`PRODUCT_ID` AS `PRODUCT_ID`,`s`.`PRODUCT_NAME` AS `PRODUCT_NAME`,`s`.`PRODUCT_DESCRIBE` AS `PRODUCT_DESCRIBE`,`s`.`AMOUNT_UNIT` AS `AMOUNT_UNIT`,`s`.`COST_PRICE_SUM` AS `COST_PRICE_SUM`,`s`.`AMOUNT` AS `AMOUNT`,`s`.`COST_PRICE` AS `COST_PRICE`,`s`.`ADDRESS_GROUP` AS `ADDRESS_GROUP`,`s`.`REGISTER_TIME` AS `REGISTER_TIME`,`s`.`type` AS `type`,`s`.`BALANCE_TYPE` AS `BALANCE_TYPE`,`d`.`PRODUCT_CLASS` AS `product_class`,`d`.`ggxh` AS `ggxh`,`d`.`cc` AS `cc`,`d`.`dx` AS `dx`,`d`.`FACTORY_NAME` AS `factory_name`,`d`.`rs1` AS `rs1`,`d`.`rs2` AS `rs2`,`d`.`rs3` AS `rs3`,`d`.`rs4` AS `rs4` from (`design_file` `d` join `stock_balance` `s`) where (`s`.`PRODUCT_ID` = `d`.`PRODUCT_ID`);