CREATE OR REPLACE VIEW post_user AS SELECT
posts.* ,users."name"
FROM
posts
left join users on posts.user_id = users.id
[数据库实战]sql创建一个view视图
于 2019-07-18 17:40:03 首次发布
CREATE OR REPLACE VIEW post_user AS SELECT
posts.* ,users."name"
FROM
posts
left join users on posts.user_id = users.id