I often find inherited SQL to be poorly formatted. Just getting things to line up helps me wrap my mind around what's going on.

My first step is to copy & paste the code into http://poorsql.com and take the formatted SQL into a new window. You can set the formatting options to match your standards/preferences.

Rob