Reputation: 21
How can I change this code to see both column A and D in the result?
SQL> SELECT A FROM R WHERE EXISTS (SELECT D FROM S WHERE S.D=R.A AND S.C=R.B);
Result:
A ---------- 1
Upvotes: 2
Views: 872
Reputation: 288
SELECT R.A, S.D FROM R INNER JOIN S ON S.D = R.A AND S.C = R.B
Upvotes: 1
Reputation: 10976
Select A, D From R Inner Join S On S.D = R.A And S.C = R.B
Upvotes: 4