|< < 21 > >|

Join

Recursive schema and query

Who is Stanley Hudson's boss's boss?
select bb.name from Employee e, Employee b, Employee bb where e.name = 'Stanley Hudson' and e.boss_id = b.emp_id and b.boss_id = bb.emp_id

|< < 21 > >|