sql创建一个view视图

CREATE OR REPLACE VIEW post_user AS SELECT posts.* ,users."name" FROM posts left join users on posts.user_id = users.id