Self Inner Join

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.