Question: Joining of tables allows you to join multiple tables using different techniques. A part of payroll system of an organisation is shown in Table 1.

Joining of tables allows you to join multiple tables using different techniques. A part of payroll system of an organisation is shown in Table 1. Assume that the first three tuples are assigned to X and the second three tuples are assigned to be Y.

Joining of tables allows you to join multiple tables using different techniques.

Perform outer joining operations on these tuples by answering the following questions:

1.1 Display the whole (full) outer join of the provided Table 1 with itself (Condition Staff_id=Staff_id).

Table 1 Staff_id Name Age Level 0001 Themba 34 7 0002 Julian 43 9 0003 Christopher 26 Null 0004 Mandla 56 10 0005 Tobogo 37 7 0006 Samson 29 Null

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!