Query Help 1

[overDeveloper]

Given the follwoing table:

id name parentid
1 aaa 0
2 bbb 0
3 ccc 0
4 ZZZ 1
5 YYY 1
6 XXX 3

How can I make a query to produce the follwoing strings:

aaa
aaa/ZZZ
aaa/YYY
bbb
ccc
ccc/XXX

 

[gmmastros]

Try this...

Select A.Name + '/' + B.Name As OutputColumn
From   [!]TableName[/!] A
       Inner Join [!]TableName[/!] B
         On A.Id = B.ParentId
Union All

Select Name
From   [!]TableName[/!] 
Where  ParentId = 0

Order By OutputColumn

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom