CODE EXAMPLE FOR SQL

sql join 3 tables

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