Question

what is join? explain its type with example
​

Answer 1

Answer:

Different Types of SQL JOINs

(INNER) JOIN: Returns records that have matching values in both tables. LEFT (OUTER) JOIN: Returns all records from the left table, and the matched records from the right table. RIGHT (OUTER) JOIN: Returns all records from the right table, and the matched records from the left table.

Explanation:

this may help u..

Answer 2

Answer:

DBMS, a join statement is mainly used to combine two tables based on a specified common field between them. We can use either 'on' or 'using' clause in MySQL to apply predicates to the join queries. A Join can be broadly divided into two types