JOIN: tying tables together
In relational databases data is split across tables. To get a meaningful answer (e.g. a student’s name and pass type), you temporarily join tables on a shared field—usually PK and FK. That is what JOIN does.
In relational databases data is split across tables. To get a meaningful answer (e.g. a student’s name and pass type), you temporarily join tables on a shared field—usually PK and FK. That is what JOIN does.