Join of tables with multiple similar field names

[#1]

I want to join two tables that have multiple similar field names which causes an 'ambiguous' error. I think its because I have a CASE WHEN statement already written on one of the similar fields. How do I change the field name of a field which I have a case when statement written from? Please advise.

Thanks,

Jared

[swuehl]

Please avoid posting duplicates:

Joining Tables with multiple similar field names

It makes it hard to follow a disussion.

Thank you.