Inner and left join on the same tables

Question

I have two tables (A and B) with two columns in common (x and y). I'd like to inner join A and B on x but keep only the values of A's column y (the left join). I'm looking for a way that will combine the two y columns (can't just specify A.y in the select statement). How can I do this?

Example

Table A

Table B

x  y
1  2
3  8
9  null
11 0

I'd like the resulting table to look like

x  y
1  2
3  4

Eh? Can you provide an example? – podiluska Sep 05 '12 at 15:11 — podiluska, Sep 05 '12 at 15:11
Question is unclear, please provide an example. – Diego Sep 05 '12 at 15:13 — Diego, Sep 05 '12 at 15:13

D'Arcy Rittich · Accepted Answer · 2012-09-05T15:34:01.077

1

select a.x, a.y
from TableA a
inner join TableB b on a.x = b.x

edited Sep 05 '12 at 15:34

answered Sep 05 '12 at 15:11

D'Arcy Rittich

167,292
40
290
283

Edited query based on subsequent info provided. – D'Arcy Rittich Sep 05 '12 at 15:34

score 0 · Answer 2 · answered Sep 05 '12 at 15:12

0

Do you mean:

SELECT *
FROM A
INNER JOIN B b1 ON A.x = b1.x
LEFT JOIN B b2 ON a.y = b2.y

answered Sep 05 '12 at 15:12

Mahmoud Gamal

78,257
17
139
164

score 0 · Answer 3 · edited May 23 '17 at 12:12

0

Take a look at SQL exclude a column using SELECT * [except columnA] FROM tableA? Second answer. Not the best solution, but you can use this as a workaround. In general, you should specify the full list of columns explicitly.

edited May 23 '17 at 12:12

Community

1
1

answered Sep 05 '12 at 16:00

Artur Udod

4,465
1
29
58

Inner and left join on the same tables

3 Answers3

Linked

Related