PART_CD | PART_NM | DEPTH

001  | 서울 | 1
001001 | 양재지점| 2
001001001 | 양재1동점| 3
002  | 경기 | 1
002001 | 수원지점| 2
002001001 | 화서1동점| 3

위와 같은 데이터가 있을 때 '001001001' 코드로 조회를 했을 때
'서울-양재지점-양재1동점' 처럼 결과가 나오게 하는 방법을 알려주세요..

/*
CREATE TABLE DBO.AGENT_AREA(
 PART_CD VARCHAR(100) NOT NULL,
 PART_NM VARCHAR(100) NOT NULL,
 DEPTH INT NOT NULL
)

INSERT INTO DBO.AGENT_AREA(PART_CD, PART_NM, DEPTH) VALUES('001','서울',1)
INSERT INTO DBO.AGENT_AREA(PART_CD, PART_NM, DEPTH) VALUES('001001','양재지점',2)
INSERT INTO DBO.AGENT_AREA(PART_CD, PART_NM, DEPTH) VALUES('001001001','양재1동점',3)
INSERT INTO DBO.AGENT_AREA(PART_CD, PART_NM, DEPTH) VALUES('002','경기',1)
INSERT INTO DBO.AGENT_AREA(PART_CD, PART_NM, DEPTH) VALUES('002001','수원지점',2)
INSERT INTO DBO.AGENT_AREA(PART_CD, PART_NM, DEPTH) VALUES('002001001','화서1동점',3)
*/