Linking on names rather than ids about db-morning-challenge HOT 3 CLOSED

Someone else just casted and showed this solution:

SELECT posts.mentor_name, COUNT(likes.post_num) 
FROM likes INNER JOIN posts
ON likes.post_num = posts.num
GROUP BY posts.mentor_name

Which shows you don't need to link on name, but you do still link on "num" rather than "id" which I still find a wee bit confusing.

from db-morning-challenge.

@ZooeyMiller , you're right about it being good practice to put an id in the table as a primary key, but you can still join by any column you'd like and it doesn't have to be the id.

from db-morning-challenge.

Closing, this is now outdated

from db-morning-challenge.