0% completed

All LessonsFree Lessons (6)

Introduction

Introduction Relational vs Non-Relational MySQL History & Architecture

Basic SQL

Exploring MySQL Create Database Data Types Create Table ... continue Temporary Table Collations & Character Sets Inserting Data Querying Data LIKE Operator Combining Conditions ORDER BY LIMIT Deleting Data TRUNCATE Updating Data Primary Key and Indexes ... continued Alterations Alter Index More on Alter Alias DISTINCT Aggregate Methods GROUP BY HAVING

Joins

Self Inner Join

Left and Right Joins

Nested Queries

Nested Scalar Queries Nested Column Queries Nested Row Queries EXISTS Operator Correlated Queries

Multi Table Operations

Multi-Table Delete Multi-Table Update SELECT and INSERT REPLACE

Views

Creating a View Updating a View With Check Option Local & Cascaded Check Drop, Show, & Rename Views

Stored Procedures

What are Stored Procedures?Create, Delete, and Alter a Stored Procedure Variables Parameters Conditional Statements Iterative Statements Cursors Error Handling SIGNAL and RESIGNAL Stored Functions

Triggers

What are Triggers?Create and Delete a Trigger INSERT Triggers UPDATE Triggers DELETE Triggers Multiple Triggers

Miscellaneous

Transaction EXPLAIN Foreign Keys

Practice & Prep

Quiz 1 Quiz 2 Quiz 3 Quiz 4 Quiz 5 Quiz 6 Quiz 7 Quiz 8 Quiz 9 Quiz 10 Quiz 11 Quiz 12 Quiz 13 Quiz 14 Quiz 15 Quiz 16 Practice Set 1 Solution Practice Set 1 Practice Set 2 Solution Practice Set 2 Practice Set 3 Solution Practice Set 3 Practice Set 4 Solution Practice Set 4 Practice Set 5 Solution Practice Set 5 Practice Set 6 Solution Practice Set 6 Cheat Sheet

Epilogue

An Introductory Guide to SQL/

...

/

Self Inner Join

Self Inner Join

This lesson discusses how to join a table with itself.

We'll cover the following...

Self Inner Join
- Syntax

Self Inner Join

The simplest join one can use is the inner join. Rows from two tables are joined together using a common column between them.

Syntax

SELECT *

FROM table1

INNER JOIN table1

ON <join condition>;

Connect to the terminal below by clicking in the widget. Once connected, the command line ...