10 lines
262 B
MySQL
10 lines
262 B
MySQL
|
CREATE OR REPLACE DEFINER=`root`@`localhost`
|
||
|
|
SQL SECURITY DEFINER
|
||
|
|
VIEW `hedera`.`myOrderTicket`
|
||
|
|
AS SELECT `o`.`id` AS `orderFk`,
|
||
|
|
`ot`.`ticketFk` AS `ticketFk`
|
||
|
|
FROM (
|
||
|
|
`hedera`.`myOrder` `o`
|
||
|
|
JOIN `hedera`.`orderTicket` `ot` ON(`ot`.`orderFk` = `o`.`id`)
|
||
|
|
)
|