Is there a way to step through an SQL from Run SQL Scripts on PC

I have a Business Intelligence developer who has created a SQL query that is acting weird. When they run it against production it takes a few seconds and works perfectly. When he changes the SQL to use a copy of one table in another library the SQL runs forever and has to be canceled. I'm trying to figure out where it is going haywire but I'm not seeing anything.

I'd really like to step through the SQL somehow and see what is what is happening. Is that an option somehow?

Any suggestions?

Respectfully,
Kendall Kinnear
System Analyst
Standard Motor Products, Inc.
Work: 972-316-8169
Mobile: 940-293-7541
________________________________

Please consider the environment before printing this email.

The content of this e-mail (including any attached files) is confidential and may be privileged and protected by law. It is intended solely for the purpose of the person to whom it is addressed. If you are not the intended recipient of this message, please notify the sender immediately and delete the message (inclusive of any attached files). In addition, if you are not the intended recipient of this message, any disclosure, copying, distribution or taking any action in reliance of the contents of this email is strictly prohibited.