CIS 336 STUDY Extraordinary Success /cis336study.com CIS 336 STUDY Extraordinary Success /cis336study.c | Page 61

FOR MORE CLASSES VISIT
www.cis336study.com
CIS336: Lab5: Joining Tables
LAB OVERVIEW
Scenario and Summary
Lab 5 will introduce the concept of multi-table JOINS in order to
work with data in two or more related tables simultaneously. This
lab may be completed using either DeVry‘sOmnymbus EDUPE-
APP lab environment, or a local copy of the MySQL database
running on your own computer using the OM database tables. The
lab will utilize a set of tables that are represented by the ERD
(OM_ERD.docx) and are created and populated by the script file
(create_OM_db.sql). Follow the instructions in the file
CreateOMTables.docx to create your database, tables, and data.
A few IMPORTANT things to note if using EDUPE MySQL:
**There can be NO SPACES in alias names given to a column. For
example:
Select unit_price as ―Retail Price ― from items; –this does NOT
work in EDUPE MySQL.
Any of the following WILL WORK:
Select unit_price as ―RetailPric e‖ from items;
Select unit_price as ―Retail_Price‖ from items;
Select unit_price as Retail_Price from items;
Select unit_price as RetailPrice from items;