Question

281 viewsDecember 18, 2023Database#Database

1

Shathana. S.R.3.26K May 23, 2023 0 Comments

explain their types.

score 0 · Answer 1 · 2023-12-18T14:31:34+00:00

INNER JOIN: Returns rows with matching values in both tables.

LEFT JOIN: Returns all rows from the left table and matching rows from the right table.

RIGHT JOIN: Returns all rows from the right table and matching rows from the left table.

FULL JOIN: Returns all rows with matches in either table.

CROSS JOIN: Returns the Cartesian product of both tables, producing all possible combinations.

Questions