Vidéo

How an inner join works in SQL

An inner join keeps only the rows that match on both sides.

Four people, four orders. Three orders name a person who exists, so those pairs lock together. Ben has no order and order 103 points at person 6, who is not there. Both are left out.

Save it for the next time a join loses rows you expected.

#sql #database #innerjoin #coding #learntocode