JOINS

Using the SELECT command you can retrieve data from several related tables also. But this is possible only if the tables are related with one other. Join operation is used to combine columns from multiple tables. In a join, the tables to be included in the query are specified in the FROM clause, separated by commas. The condition required for specifying the relationship between the tables is given in the WHERE clause.

The syntax for SELECT statement where we JOIN two tables in mentioned below:

SELECT <COLUMNS> FROM <TABLE1>, <TABLE2>,.... <TABLE N>;