Reverse returning values in MySQL?

Question

OK, given the following dataset:

ID , name    , lineManagerKey, lineManagerName
 1 , Joe     , null          , null
 2 , Herbert ,    1          , Joe
 3 , John    ,    1          , Joe
 4 , George  , null          , null
 5 , Paul    , null          , null
 6 , Ringo   , null          , null
 7 , Frank   , null          , null
 8 , Jeff    ,    7          , Frank

I want to return the following:

Manager,Minion
Joe,Herbert
Joe,John
Frank,Jeff

Every way I am thinking of the possible query it seems to want to return multiple rows? Any ideas?

Possible duplicate of [How to create a MySQL hierarchical recursive query](https://stackoverflow.com/questions/20215744/how-to-create-a-mysql-hierarchical-recursive-query) — Raymond Nijland, Nov 30 '18 at 16:13
Why do you have both lineManagerKey and lineManagerName? It sounds like you have a LineManager table which already maps keys to names? — Lightness Races in Orbit, Nov 30 '18 at 16:28
You can pretty much ignore the Line Manager Name, but I added it in, in this case so you visualise the data structure better. — Steven W, Nov 30 '18 at 16:30

score 1 · Accepted Answer · answered Nov 30 '18 at 16:16

1

select lineManagerName as Manager,name as Minion from table where lineManagerName is not null;

answered Nov 30 '18 at 16:16

Reda Meskali

275
3
9

Thanks for that... I was going round in circles and somehow not actually finding the solution. – Steven W Nov 30 '18 at 16:32

Reverse returning values in MySQL?

1 Answers1