Consider a scenario, there are three tables name ‘X’, ‘Y ‘and’ Z’ with schemes X (u, v, w), Y (l, u, m, n, o, p) and Z (r, s, t, u, q), These tables have a common attribute or field. We want to retrieve the data from these tables. In this scenario, discuss which join operation can help to retrieve the records from multiple tables.
Justify your answer with at least two solid arguments.

I prefer to useINNER JOIN for this type of scenario its logical arguments are as follows:

The INNER JOINSelects all rows from all participating tables as long as there is a match between the columns.

INNER JOIN is for clarity. Using Where as in your second example can get lost in more complex queries, making it difficult to determine how your tables are joined and make it more difficult to troubleshoot problems.

INNER JOIN is faster to pull more rows.

JOIN works by concentrating the operation on the result of the first all tables, any subsequent joins would concentrate joining on the in memory result of the first joined tables and so on less read write needle movement, thus faster.

Explanation:

answerpanning and scanning;