Crear vistas

Para crer vistas usamos ‘CREATE VIEW’:

https://dev.mysql.com/doc/refman/8.0/en/create-view.html

https://www.anerbarrena.com/create-view-mysql-5101/

https://www.mysqltutorial.org/create-sql-views-mysql.aspx/

CREATE VIEW `actores_peliculas` AS
    SELECT 
        `actor`.`first_name` AS `first_name`,
        `actor`.`last_name` AS `last_name`,
        `film`.`title` AS `title`
    FROM
        ((`actor`
        JOIN `film_actor` ON ((`actor`.`actor_id` = `film_actor`.`actor_id`)))
        JOIN `film` ON ((`film_actor`.`film_id` = `film`.`film_id`)))