Go to column ' id ' in field list is ambiguous problem

Column ' id ' in field list is ambiguous
This error is because the ID field in your query statement does not indicate which table is the ID field, and it should be distinguished by a table name (or alias).

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


Examples of using aliases:
Examples of distinguishing by table name:
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 that you can read the alias on the line, when you write the table name good


Add: The parameters of the left function must be a field, the completion form of the field is added to the table name, left before the table name will be syntactically wrong, it should be:
Select Left (student.name, 10) .....

Go to column ' id ' in field list is ambiguous problem