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

7 lines
199 B
SQL

CREATE OR REPLACE DEFINER=`root`@`localhost`
SQL SECURITY DEFINER
VIEW `vn2008`.`tickets_gestdoc`
AS SELECT `td`.`ticketFk` AS `Id_Ticket`,
`td`.`dmsFk` AS `gestdoc_id`
FROM `vn`.`ticketDms` `td`