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))