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

7 lines
215 B
MySQL
Raw Permalink Normal View History

CREATE OR REPLACE DEFINER=`root`@`localhost`
SQL SECURITY DEFINER
VIEW `vn2008`.`albaran_gestdoc`
AS SELECT `dnd`.`dmsFk` AS `gestdoc_id`,
`dnd`.`deliveryNoteFk` AS `albaran_id`
FROM `vn`.`deliveryNoteDms` `dnd`