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

9 lines
258 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`.`Splits`
AS SELECT `s`.`id` AS `Id_Split`,
`s`.`ticketFk` AS `Id_Ticket`,
`s`.`entryFk` AS `Id_Entrada`,
`s`.`dated` AS `Fecha`,
`s`.`note` AS `Notas`
FROM `vn`.`split` `s`