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

8 lines
249 B
MySQL
Raw Permalink Normal View History

CREATE OR REPLACE DEFINER=`root`@`localhost`
SQL SECURITY DEFINER
VIEW `vn2008`.`recibida_intrastat`
AS SELECT `i`.`invoiceInFk` AS `recibida_id`,
`i`.`intrastatFk` AS `Codintrastat`,
`i`.`amount` AS `importe`
FROM `vn`.`invoiceInIntrastat` `i`