column 'id' in field list is ambiguous

 select student.id, student.name, score.total
 from student, score
 where student.id = score.id
mysql> create view com
    -> as
    -> select test.id,test.age
    -> from test,users
    -> where test.id=users.id;