Thanks for all of your help!!

I tried what what you said and I get the following error:

Server: Msg 156, Level 15, State 1, Procedure V_TRANSCRIPTS_SA2, Line 33

Incorrect syntax near the keyword 'INNER'.

Thanks for you help!:)