JOIN
clause is used to create a new table by combining records and using common fields between two tables in a database.
JOIN
clause.JOIN
clause:
SELECT table_1.column_1, table_2.column_2...
will select the columns to be displayed from both tables.FROM table_1 JOIN table_2
represents the joined tables.ON table_1.common_filed = table_2.common_field
compares each row of table_1 with each row of table_2 to find all pairs of rows that meet the join-common field.JOIN
query as follows: