Self Inner Join
This lesson discusses how to join a table with itself.
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 ...
Get hands-on with 1400+ tech skills courses.