stock_blance_design_file_view创建

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`);