SQL - Remove column with same name

Question

Possible Duplicate:
Inner and left join on the same tables

I currently have this statement

SELECT A.*, B.* FROM A a INNER JOIN B b ON A.x = B.x

However, A and B both have a second commonly named column: y. I'd like to only have the y column from A (exclude the one from B), without removing the A.* and B.* parts (many other columns in each table that may or may not always be there). Is this possible?

Example

A

B

x  y
0  8
1  null
9  7

result

x  y
0  3
1  4

@Andrew, please don't re-post the same question, I've already answered this for you here: http://stackoverflow.com/a/12284527/39430 — D'Arcy Rittich, Sep 05 '12 at 15:40
@Andrew why do you want to use `A.*` or `B.*`? Why not specify the column names? — Taryn, Sep 05 '12 at 15:44
as i've said in my answer below (*which was downvoted*), you can't because, asterisk means `ALL` — Pedigree, Sep 05 '12 at 15:44

score 0 · Answer 1 · edited May 23 '17 at 11:49

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 11:49

Community

1
1

answered Sep 05 '12 at 15:47

Artur Udod

4,465
1
29
58

SQL - Remove column with same name

1 Answers1