Question: X: SELECT [list] FROM Table_Left L INNER JOIN Table_Right R ON L.Key = R.Key ; Y: SELECT [list] FROM Table_Left L FULL OUTER JOIN Table_Right
X: SELECT [list] FROM Table_Left L INNER JOIN Table_Right R ON L.Key = R.Key ;
Y: SELECT [list] FROM Table_Left L FULL OUTER JOIN Table_Right R ON L.Key = R.Key ;
Z: SELECT [list] FROM Table_Left L FULL OUTER JOIN Table_Right R ON L.Key = R.Key WHERE L.Key IS NULL OR R.Key IS NULL ;
Does this mean X = Y minus Z?
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
Study Help