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

7 lines
210 B
MySQL
Raw Permalink Normal View History

2024-01-30 06:48:29 +00:00
CREATE OR REPLACE DEFINER=`root`@`localhost`
SQL SECURITY DEFINER
VIEW `vn2008`.`Proveedores_gestdoc`
AS SELECT `sd`.`supplierFk` AS `Id_Proveedor`,
`sd`.`dmsFk` AS `gestdoc_id`
FROM `vn`.`supplierDms` `sd`