MySQL:Task:Joins and Relations

From virtualMV2015wiki
Jump to: navigation, search
 Home  MySQL <

Introduction

Icon Objective.png

Objective

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 http://www.virtualmv.com/wiki/index.php?title=MySQL%3ATask%3AJoins_and_Relations    (zotero)