When I have two Tables A(id, name) and B(id, age) I want to join. through: SELECT * FROM A
INNER JOIN B ON A.id=B.id and also through: SELECT * FROM A
INNER JOIN B USING(id) in both ways, I get a table with duplicate key columns "id" from both previous tables: (id, name, id, age) What I want is (id, name, age), so the key columns should merge. EDIT: I know I could do it through "SELECT A.id, name, age..." instead of "SELECT * ...", but I have many columns, that I don't want to go this workaround.
... View more
