You can add the JOIN... ON clause following the FROM keyword in the SELECT statement to join tables and query data from these tables.
Syntax
The business of joined tables is associated. For example, some definitions of field values and data are the same. This association is a join condition and can be enclosed in the brackets following the ON keyword in the JOIN... ON statement. Filter conditions can be also contained in the ON statement. Syntax for the SQL statement:
SELECT select_list FROM table_name1 [INNER|LEFT|RIGHT] JOIN table_name2 ON join_condition
WHERE query_condition
Usage notes
Most join queries contain at least one join condition in the FROM or WHERE clause. Multi-table join queries can be used with the GROUP BY, HAVING, ORDER BY, and LIMIT statements.
The select_list clause can select any column from the tables specified in the FROM clause. If any two tables have the same column name, the table names must be specified in the entire query to define indexing to these columns.