How can I use the table name in a column alias in Access SQL?

Question

In MS Access, my table is:Exam{id,name}, and my query is

select Exam.id as 'Exam.id',Exam.name as 'Exam.name' from Exam

Now when I execute this query this error ocured:

"Exam.id" is not a valid name. Make sure that it does not include invalid characters or punctuation and that it is not too long.

I want to use the full table + column as the alias, Exam.name as 'Exam.name', but I don't know how i can get Access to accept it.

Thanks for your attention.

Answer 1

As the error indicates, punctuation is not allowed in an alias in MS Access. Consider revising your query to eliminate punctuation.

select e.id as 'ExamId', 
    e.name as 'ExamName' 
from Exam e