Selgitage SQL-is FULL JOIN operatsiooni tööpõhimõtet ja millal seda kasutatakse.

The FULL JOIN operation in SQL combines rows from two tables based on a specified join condition and returns all rows from both tables. If a row from one table has no match in the other, the missing columns will have NULL values in the result set.

FULL JOIN is used when you need to obtain a complete dataset from both tables, including both matching and non-matching records.

Example:

SELECT A.id, A.name, B.order_id
FROM Customers A
FULL JOIN Orders B ON A.id = B.customer_id;

The result will include all customers and all orders, even if a customer has no orders or an order is not linked to a customer.