Hi Mike,
You are correct, when using the "Loop through Table" action, you do not have access to any other SQL commands other than the "Where" clause, you do not have access to the Advanced Script features that "Retreive value From Table" can offer.
-Ben