SQL Server: Inner Join

Description

In SQL Server, an INNER JOIN retrieves records that have matching values in both tables. It only includes rows where the join condition is met in both the left and right tables.

In this lab, you will be learning how to use Inner Joins in SQL Server and their purposes.

Based on this Schema, generate the solutions to the respective queries listed below:

1. List all suppliers with their products, sorted by company.
2. List all orders with customer information.
3. List all orders with product names, quantities, and prices.

Lab Objective

Upon completion of this lab, you will be able to:

• Gain Hands-On Experience on SQL Server Inner Joins

Prerequisites

• You should have a conceptual understanding of Joins.
• You must have SQL Server Installed on your systems.