Column ' ID ' in the field list is ambiguous

Column ' ID ' in the field list is ambiguous
This error, because you have the ID field in the query statement, there is no description of which table ID field, should be added table name (or alias) to distinguish.


Examples of distinguishing with table names:
Select Student.id, Student.name, Score.total
From student, score
where student.id = Score.id


Examples of using aliases:
Examples of distinguishing with table names:
Select S.id, S.name, C.total
From student S, score C
where s.id = C.id


Many textbooks are used in a large number of aliases, in fact, for beginners, I suggest you understand the alias on the line, write their own time with a table name good


Add: Left function argument must be a field, the field is completed in the form of a table name, left before the table name will be grammatically incorrect, it should be this way:
Select Left (student.name, 10) ...