Create Simple Join[SQL] - Exercise

RelationalDBDesign

SiteMap

Essential SQL

Interview Questions

SQL Joins «Prev Next»

SQL Introduction
Course Prerequisites
Select Statement
What is SQL
SQL 92
SQL Dialect Variations
Relational Databases
Relational vs Flatfile
Different Storage Formats
Relational DB Analogy
Data Table Example
Normalization Example Table
Three Normalization Levels
SQL Foundations
Database Elements
Databases Column Types
Create Index Column
Database Foundations - Quiz
Table Querying
SQL Conclusion
INTO Statement
Order By Clause
SQL Into Statement
Filtering Select Statement
Joining Tables

Create Simple Join - Exercise

Objective: Create a statement that will provide the specified join.
Consider the following tables for this exercise:
Customer

Cust_ID

lastname

firstname

address

city

state

zip_code

Orders

Order_ID

Cust_ID

Item_ID

Qty

OrderDate

Create a statement that will return each order line with its associated customer. When you are done, submit your answer to the tutor.

SQL Joins