8 lines
250 B
MySQL
8 lines
250 B
MySQL
|
CREATE OR REPLACE DEFINER=`root`@`localhost`
|
||
|
|
SQL SECURITY DEFINER
|
||
|
|
VIEW `vn2008`.`Pagares`
|
||
|
|
AS SELECT `p`.`id` AS `Id_Pagare`,
|
||
|
|
`p`.`issued` AS `Fechaemision`,
|
||
|
|
`p`.`Concept` AS `Concepto`,
|
||
|
|
`p`.`paymentFk` AS `pago_id`
|
||
|
|
FROM `vn`.`promissoryNote` `p`
|