For instance let’s say I have the following stored procedure.

SELECT apples 
FROM Fruits T
JOIN Things T2 ON T.Id = T2.FruitId

How can I easily know which table “apples” is from? T or T2? Obviously in this example it would be easy to figure out but in some of the code I have inherited it is not at all. Multiple databases, JOINs for days, it’s a pain trying to figure out what table is providing what data.