数据库列名重复

Duplicate column name ‘id’
重复列名“id”
第一种
create view student_class_v1 AS
select s.*,c.id as cid ,c.name as cName from my_class c left join
my_student2 s on c.id=s.class_id;
select * from student_class_v1
第二种
create view student_class_v1 AS
select * from my_class right JOIN
my_student2
using(id,name);