INNER JOIN on self table

Question

I want to do a INNER JOIN on a table on himself to get only one value, so i make

SELECT *,u2.name AS ownername FROM user u INNER JOIN user u2 ON u.owner = u2.id

The problem i have is that if I try for example to print the id value, it takes it from the u2 values... And there is too many fields to rename all of them with u.id AS... u.surname AS...

I think this will be easy to fix but i dont know how :(

Thank you for any idea

possible duplicate of [MySql. How to use Self Join](http://stackoverflow.com/questions/16701920/mysql-how-to-use-self-join) — void, Apr 13 '15 at 22:48
`ON u.owner = u.id` should be `ON u.owner = u2.id` (or perhaps the other way around - table structures not given). — Turophile, Apr 13 '15 at 22:52
Submitted as an answer so it can be accepted and the question closed. — Turophile, Apr 13 '15 at 23:04

score 1 · Accepted Answer · answered Apr 13 '15 at 23:03

1

You want:

SELECT u.*,u2.name AS ownername FROM user u INNER JOIN user u2 ON u.owner = u2.id

answered Apr 13 '15 at 23:03

Turophile

3,367
1
13
21

INNER JOIN on self table

1 Answers1