RelationalDBDesign
SiteMap
Advanced SQL
Essential SQL
Interview Questions
SQL Joins
«Prev
Next»
SQL Introduction
Course Prerequisites
Select Statement
What is SQL
Client/Server Request
SQL 92 (History)
SQL Dialect Variations
Relational Databases
Relational vs Flatfile
Different Storage Formats
Relational DB Analogy
Database Normalization
Data Table Example
Normalization Example Table
Table Normalization - Exercise
Three Normalization Levels
Relational Flatfile DB
SQL Columns Rows
SQL Foundations
Database Elements
Database Parts - Quiz
Database Spreadsheets
Databases Column Types
Create Index Column
SQL Select Statement
Selecting Information
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.
Submit