sql on how to select three table and all columns for a joined table code example

Example: sql join 3 tables

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