user1837225
user1837225

Reputation: 21

SELECT statements - add additional column to result set

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

Answers (2)

pjwilliams
pjwilliams

Reputation: 288

SELECT R.A, S.D
FROM R
INNER JOIN S ON S.D = R.A AND S.C = R.B

Upvotes: 1

Laurence
Laurence

Reputation: 10976

Select 
  A, D
From
  R
    Inner Join
  S
    On S.D = R.A And S.C = R.B

Upvotes: 4

Related Questions