我有一張如下表
ID LOCATION PARENTID
445632 SPND0237 0
521847 SPND0237A 445632
我需要像下面這樣的輸出
ID LOCATION PARENT_NAME PARENTID
445632 SPND0237 NULL 0
521847 SPND0237A SPND0237 445632
我正在使用以下查詢
select a.ID, a.LOCATION, b.LOCATION as PARENT_NAME, a.PARENTID
from table as a
left join table as b on a.PARENTID = b.ID
但沒有得到結果。
uj5u.com熱心網友回復：
create table #emp (
ID int primary key,
LOCATION varchar(100),
PARENTID int
)
insert into #emp values (445632 ,'SPND0237', 0)
insert into #emp values (521847 ,'SPND0237A', 445632)
--select * from #emp
select a.ID, a.LOCATION, B.LOCATION AS PARENT_NAME, A.PARENTID
from #emp a left join #emp b on A.PARENTID = B.ID
您給定的查詢有效，沒有問題
轉載請註明出處，本文鏈接：https://www.uj5u.com/caozuo/327522.html