Self Inner Join
This lesson discusses how to join a table with itself.
We'll cover the following
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 prompt will show up. Enter or copy and paste the command ./DataJek/Lessons/25lesson.sh and wait for the MySQL prompt to start-up.
Level up your interview prep. Join Educative to access 70+ hands-on prep courses.