salix/db/routines/vn2008/views/cl_det.sql

9 lines
244 B
MySQL
Raw Permalink Normal View History

CREATE OR REPLACE DEFINER=`root`@`localhost`
SQL SECURITY DEFINER
VIEW `vn2008`.`cl_det`
AS SELECT `c`.`id` AS `id`,
`c`.`claimFk` AS `cl_main_id`,
`c`.`saleFk` AS `Id_Movimiento`,
`c`.`quantity` AS `numero`
FROM `vn`.`claimBeginning` `c`