pour faire une vue

CREATE VIEW database1.view_name
AS 
(SELECT * FROM database2.other_view_name WHERE... ORDER BY)

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