Torna al Thread

SELECT Tabe.IdPP, Tabe.UsNo, Tabe.IdRe, 1 AS Livx FROM Tabe WHERE Tabe.IdPP=3 UNION ALL SELECT Tabe.IdPP, Tabe.UsNo, Tabe.IdRe, 2 AS Livx FROM Tabe WHERE Tabe.IdRe=3 UNION ALL SELECT Tabe.IdPP, Tabe.UsNo, Tabe.IdRe, 3 AS Livx FROM Tabe WHERE Tabe.IdRe IN (SELECT Tabe.IdPP FROM Tabe WHERE Tabe.IdRe=3) UNION ALL SELECT Tabe.IdPP, Tabe.UsNo, Tabe.IdRe, 4 AS Livx FROM Tabe WHERE Tabe.IdRe IN (SELECT Tabe.IdPP FROM Tabe WHERE Tabe.IdRe IN (SELECT Tabe.IdPP FROM Tabe WHERE Tabe.IdRe=3))
Copyright © dotNetHell.it 2002-2025
Running on Windows Server 2008 R2 Standard, SQL Server 2012 & ASP.NET 3.5