How to go through a hierarchy?

Question

Viewing post 1 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Grant Fritchey SSC Guru Points: 399330 More actions · Answer 1

Take a look at today's article on CTE's. It shows several methods that might help with this question:

Depending on how complicated you want to get with the query, you could simply join the table to itself.

SELECT t1.pname

FROM table t1

JOIN table t2

ON t1.pno = t2.old_pno

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt