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

更多推荐

[数据库实战]sql创建一个view视图