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

START TRANSACTION;



--
-- Database: `ch_trenesanas_eksamenam_1`
--

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

--
-- Structure for view `ch_result_1`
--

CREATE ALGORITHM=UNDEFINED DEFINER=`cinkmanis_h`@`localhost` SQL SECURITY DEFINER VIEW `ch_result_1`  AS SELECT `d`.`UR` AS `Darba nr`, `d`.`poz` AS `Pozīcija`, `d`.`merv` AS `merv`, `d`.`cena` AS `cena`, `i`.`daudzums` AS `Daudzums`, round((`d`.`cena` * `i`.`daudzums`),2) AS `Kopā` FROM ((`ch_ieraksti` `i` join `ch_darbi` `d` on((`i`.`UR` = `d`.`UR`))) join `ch_akti` `a` on((`i`.`akta_id` = `a`.`akta_id`))) ;

--
-- VIEW `ch_result_1`
-- Data: None
--

COMMIT;

