13 lines
331 B
MySQL
13 lines
331 B
MySQL
|
CREATE OR REPLACE DEFINER=`root`@`localhost`
|
||
|
|
SQL SECURITY DEFINER
|
||
|
|
VIEW `hedera`.`mainAccountBank`
|
||
|
|
AS SELECT `e`.`name` AS `name`,
|
||
|
|
`a`.`iban` AS `iban`
|
||
|
|
FROM (
|
||
|
|
(
|
||
|
|
`hedera`.`mainAccount` `c`
|
||
|
|
JOIN `vn`.`supplierAccount` `a` ON(`a`.`id` = `c`.`accountFk`)
|
||
|
|
)
|
||
|
|
JOIN `vn`.`bankEntity` `e` ON(`e`.`id` = `a`.`bankEntityFk`)
|
||
|
|
)
|