DAD 220 Milestone Three.docx - Running Heading MILESTONE THREE DAD 220 Introduction to SQL Milestone Three Johnathan James Running Heading MILESTONE

DAD 220 Milestone Three.docx - Running Heading MILESTONE...

This preview shows page 1 - 3 out of 3 pages.

Running Heading: MILESTONE THREE DAD 220 Introduction to SQL: Milestone Three Johnathan James June 12, 2018
Image of page 1
Running Heading: MILESTONE THREE Task 1: Using the SELECT command to select the required columns and then using the WHERE command to link the tables using common columns (i.e. the person_id column from both the meeting and person tables). To narrow the results, I set the first_name and last_name columns to Tom and Hanks respectively to get results only in relation to that name. Task 2: Using similar commands from Task 1 to link tables and columns but changing the WHERE command to narrow the meeting_id to results that have ‘2’ in the meeting_id column. Task 3: Using similar commands from Task 1 to link tables and columns but changing the
Image of page 2
Image of page 3

You've reached the end of your free preview.

Want to read all 3 pages?

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture