DEV Community

SQL: Inner Join

Wendy Calderon on November 18, 2019

In SQL we have various powerful clauses that make managing databases possible, but one that usually brings confusion along with it's functionality,...
Collapse
 
katnel20 profile image
Katie Nelson

What if both tables had a column called 'name'. How would you select the name of the checkups table?

Collapse
 
wendisha profile image
Wendy Calderon

Good question Katie.
When a column name is not unique to a table, you would chain it to it's table name, so it would be SELECT checkups.name FROM ...

Collapse
 
katnel20 profile image
Katie Nelson

Makes perfect sense. Thanks Wendy.

Thread Thread
 
wendisha profile image
Wendy Calderon

Glad to help! :)