MySQL:Task:Joins and Relations

From virtualMV2015wiki
Jump to: navigation, search
 Home  MySQL <


Icon Objective.png


Your task for today is to become familiar with:

  • the use of joins to link two tables and
  • the use of an associative table (entity), also referred to as a transaction table) which are used to eliminate many to many relationships.

You will also use the JOIN command to retrieve information from a linked file.

Icon References.png References

MySQL:Task:Joins and Relations. (2017). In virtualMV's ( Michael Verhaart ) wiki. Retrieved December 18, 2017, from    (zotero)