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

12 lines
308 B
MySQL
Raw Permalink Normal View History

2024-01-29 08:12:29 +00:00
CREATE OR REPLACE DEFINER=`root`@`localhost`
SQL SECURITY DEFINER
VIEW `vn2008`.`gastos_resumen`
AS SELECT
2024-04-17 10:32:33 +00:00
`es`.`id` AS `id`,
2024-01-29 08:12:29 +00:00
`es`.`expenseFk` AS `Id_Gasto`,
`es`.`year` AS `year`,
`es`.`month` AS `month`,
`es`.`amount` AS `importe`,
`es`.`companyFk` AS `empresa_id`
FROM
2024-02-21 06:35:57 +00:00
`vn`.`expenseManual` `es`;