Question

Tell me the answer of this qns -which allows the user to look for and collect data from multiple tables.

Answer 1

Answer:

By using JOIN, we can fetch the data from multiple tables.

An SQL JOIN clause is used to combine rows from two or more tables, based on a common field between them. Various types of JOINS are : INNER JOIN: Returns all rows when there is at least one match in BOTH tables. LEFT JOIN: Return all rows from the left table, and the matched rows from the right table.