What are Joins? Explain different types.

Question

can you help me with this question

in progress 0
Akshathadabbara 2025-02-28T15:36:30+00:00 1 Answer 9 views
0

Answer ( 1 )

  1. Aravind
    0
    2025-02-28T15:39:28+00:00
    Reply

    Joins are used to retrieve data from multiple tables based on relationships.

    1. INNER JOIN – Returns matching records.
    2. LEFT JOIN (OUTER JOIN) – Returns all records from the left table and matching from the right.
    3. RIGHT JOIN (OUTER JOIN) – Returns all records from the right table and matching from the left.
    4. FULL JOIN (OUTER JOIN) – Returns all records from both tables.

Leave an answer