'What's the purpose of dot operation in SQL?

Might be a dumb question, still I'm a beginner with datacamp.

I am wondering at the 1st line what is the point of the dots

c.code, c.name, c.region

when I could simply write as

code, name, region

both with the same output?

with dot operations

without dot

My guess is, for both tables Countries and Population have the same column code, hence if I do not specify, which code I want my data to take out from (either from Population or Countries), then SQL will just take from the later (which is population in this case)

HOWEVER I will eventually be INNER JOINING both tables with code, so we are back to, dot operation is useless for inner join?

sql


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions