what is table join in sql code example

Example: sql join 3 tables

SELECT column-names
  FROM table-name1 JOIN table-name2 
    ON column-name1 = column-name2
 WHERE condition