SQL table transformation part 4/7 i don't why there is an A


#1

It is my first time to add a post,and thank you for your help!

I have a question here

as you can see this code and I don’t know why there is an A here


#2

There shouldn't be one. :wink:


#3

"AS" is an optional operator for table alias.
But I think using "AS" before alias name would be more clear.

ref link:


#4

"a" is the name of the virtual datatable that contains de values of the inner query we have made.
You can see that the outer query calls the values with the traditional syntax: [dataframe_name.field_name], at the beginning of the script. But I think it's unusual to label it with a simple "a". Maybe, it would be better to label with a clearer name.


#5

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.