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

START TRANSACTION;



--
-- Database: `kns_legal`
--

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

--
-- Structure for view `stock_material_list`
--

CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `stock_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`,`ms`.`material_id` AS `material_id`,`ms`.`material_stock_project` AS `material_stock_project_id`,`ms`.`material_stock_quantity` AS `material_stock_quantity` from (`material_stock` `ms` left join `stock_material_master` `smm` on((`smm`.`stock_material_id` = `ms`.`material_id`))) ;

--
-- VIEW  `stock_material_list`
-- Data: None
--

COMMIT;

