I'm a novice in SQL and I'm trying to study the views. Initially I created a database called "university", on which I create two tables respectively called "Student" and "Grade". And now I want to create a view named "vw_Student" which can select data from the two underlying tables. the code is below: (I'm using SQL 2008)CREATE VIEW vw_StudentAS SELECT * FROM StudentINNER JOIN GradeON Student.Student_Id = Grade.Student_Id GO But after I run it, the following error shows below:Msg 4506, Level 16, State 1, Procedure vw_Student, Line 3 Column names in each view or function must be unique. Column name 'Student_Id' in view or function 'vw_Student' is specified more than once. I hope someone could help me with this small problem! Thanks a lot!!