select Column_ID,Column_Name,Parent_ID,(select Column_Name from [Sort] where Column_ID=a.Parent_ID) Parent_Name,(select Parent_ID from [Sort] where Column_ID=a.Parent_ID) Fathers_ID,(select Column_Name from [Sort] where Column_ID=(select Parent_ID from [Sort] where Column_ID=a.Parent_ID)) Father_Name from [sort] a where Column_Depth=3