11.12--sql server

1,错误：查询结果有俩个id,所以有冲突

create view testview2
as
select *
from student,  test10.dbo.chengji
where student.Id=  test10.dbo.chengji.id

下面是正确：
create view testview
as
select a.id
from test10.dbo.student as a LEFT   OUTER   JOIN test10.dbo.chengji as b
on a.id = b.id