MySql创建多表字段视图

[qq_36191093]

已知表student中有字段id,name,group_id
表group中有字段id,name
表student的group_id字段是外键表group的id字段

现在要创建一个视图，视图中有两个字段，分别是表student的name字段和表group的name字段，那sql语句怎么写

[qq_36191093]

create view v_test as select s.name as s_name,g.name as g_name from student as s join group as g on s.group_id = g.id;



自己给自己打分吧。。。