sql - Getting an error with a period should be between alias name and period?

Question

I totally thought I was over the SQL hump but still getting issues! So my code is here for example:

create volatile table final_pull as ( a.id

a.id_2

a.id_3

) commit on data perceive rows (I"m not on my work computer so I'm blanking on the actual ending for this lol)

But I keep getting an issue where they are saying I need another parathesis? and that they are missing something between the a.id. What is missing?

THank you!

Answer 1

等待大神解答