[Rabby-chan]

Не самым лучшим образом, но все-таки работающее))

SELECT [People].[Name]
	,pl1.[Name]
	,pl2.[Name]
	,pl3.[Name]
	,pl4.[Name]
	,pl5.[Name]
	,pl6.[Name]
	FROM [TestDataBase].[dbo].[Allpeople] JOIN [TestDataBase].[dbo].[People] ON People.[ID] = Allpeople.[ID_Person] JOIN [TestDataBase].[dbo].[Allplaces] pl1 ON pl1.[ID] = Allpeople.ID_All JOIN [TestDataBase].[dbo].[Allplaces] pl2 ON pl1.[ID_Parent] = pl2.[ID] JOIN [TestDataBase].[dbo].[Allplaces] pl3 ON pl2.[ID_Parent] = pl3.[ID] JOIN [TestDataBase].[dbo].[Allplaces] pl4 ON pl3.[ID_Parent] = pl4.[ID] JOIN [TestDataBase].[dbo].[Allplaces] pl5 ON pl4.[ID_Parent] = pl5.[ID] JOIN [TestDataBase].[dbo].[Allplaces] pl6 ON pl5.[ID_Parent] = pl6.[ID] 
		

@темы: ботанизм, гордое до невозможности, задушенный шакал