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 Spreadsheets
Database Parts - Quiz
Table Structure SQL
Create Table
Databases Column Types
Table Index
Create Index Column
Database Index Engine
Database Foundations - Quiz
SQL Insert
Incorrect Insert
SQL Select Statement
Selecting Information
Tables Rows Dsatabase
Querying XML
Table Querying
SQL Conclusion
INTO Statement
Order By Clause
SQL Into Statement
Filtering Select Statement
Joining Tables
Advanced SQL Join - Exercise
Objective
Create an SQL statement that will create the join specified.
Given that you have two tables with the following columns:
Table1
CustomerID
Lastname
Firstname
Table2
OrderID
CustomerID
Qty
Orderdate
Create a SQL statement that will show all customers in the database and, for any customer with an order, the orders on file. When you are done, submit your SQL statement to the tutor.
Submit
x