Oracle Database Management/Administration

profilevarshankar1221
W1A1-Join.pdf

ITU SWE 562 DBA Name ________________________ ID ________________ Given three tables R, S, and T as follows (all attributes are of type integer).

R S T

A B B C A C 7 null 6 2 3 5 3 2 2 5 7 4 null 4

Write down the result of joining table R, S, and T

SELECT R.A, S.B, T.C FROM R, S, T WHERE R.B = S.B and S.C = T.C and R.A = T.A;