discuss which join operation can help to retrieve the records from multiple tables. Justify your answer with at least two solid arguments.

Question

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.

Answer 1

You can use an Inner Join for this. U is a primary key in table X and a foreign key in table Y and Z. Moreover, U is the only common field amongst the three tables.