на всякий случай

[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] and pl2.[ID] = Allpeople.ID_All JOIN [TestDataBase].[dbo].[Allplaces] pl3 ON pl2.[ID_Parent] = pl3.[ID] and pl3.[ID] = Allpeople.ID_All JOIN [TestDataBase].[dbo].[Allplaces] pl4 ON pl3.[ID_Parent] = pl4.[ID] and pl4.[ID] = Allpeople.ID_All JOIN [TestDataBase].[dbo].[Allplaces] pl5 ON pl4.[ID_Parent] = pl5.[ID] and pl5.[ID] = Allpeople.ID_All JOIN [TestDataBase].[dbo].[Allplaces] pl6 ON pl5.[ID_Parent] = pl6.[ID] and pl6.[ID] = Allpeople.ID_All 
		WHERE pl1.[ID] BETWEEN 35 and 44 or pl2.[ID] BETWEEN 30 and 34 or pl3.[ID] BETWEEN 25 and 29 or pl4.[ID] BETWEEN 19 and 24 or pl5.[ID] BETWEEN 6 and 18 or pl5.[ID] BETWEEN 1 and 5

@темы: ботанизм, задушенный шакал