-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `kns_legal`
--

-- --------------------------------------------------------

--
-- Structure for view `issue_material_list`
--

CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `issue_material_list`  AS  select `smm`.`stock_material_code` AS `material_code`,`smm`.`stock_material_name` AS `material_name`,`smm`.`stock_material_price` AS `material_price`,`sii`.`stock_issue_item_material_id` AS `issue_material_id`,`sii`.`stock_issue_item_project` AS `material_issue_project_id`,`sii`.`stock_issue_item_qty` AS `material_issue_quantity` from (`stock_issue_item` `sii` left join `stock_material_master` `smm` on((`smm`.`stock_material_id` = `sii`.`stock_issue_item_material_id`))) ;

--
-- VIEW  `issue_material_list`
-- Data: None
--

COMMIT;

