British Sign Language Glossaries of Curriculum Terms

BSL Data Science Glossary - Join - inner definition

Definition: So we have two tables. Both have an ID or name column. For example, I'm called Ben. The first table has Ben in it, with columns including age, birth town and some others. The second table, let's have a look at it - ah, we do see a Ben there too. It contains my exam results. So we join the two together, becoming a single table with Ben's age, birth town and exam results all in a single row. Now let's look at a different person with the first table, called Pip. Let's have a look at the second table and, well, there is no Pip there. In this case, we don't include Pip in the joined table. Now, the next person on the first table is Joey, looking at the second table, there is Joey there. So we join those two up for Joey. Next person is Sarah. We see Sarah in the second table, but not in the first table, in this case, we don't include Sarah. In the end, we have only Ben and Joey in the joined table. That is what inner join is.