11 lines
322 B
SQL
11 lines
322 B
SQL
CREATE OR REPLACE DEFINER=`root`@`localhost`
|
|
SQL SECURITY DEFINER
|
|
VIEW `vn2008`.`Comparativa`
|
|
AS SELECT `c`.`timePeriod` AS `Periodo`,
|
|
`c`.`itemFk` AS `Id_Article`,
|
|
`c`.`warehouseFk` AS `warehouse_id`,
|
|
`c`.`quantity` AS `Cantidad`,
|
|
`c`.`price` AS `price`,
|
|
`c`.`countryFk` AS `countryFk`
|
|
FROM `vn`.`comparative` `c`
|