You can make separate LEFT JOINs for StatusCode and ResolutionCode into VisCodes and then use IIF(EMPTY(ResolutionCode), ...,...) in the filed list.

>
>I have a trans table which contains Status Code and Resolution Code fields. If the resolution code is not empty, I want to use it, otherwise I need to use Status Code. The code description is in another table called VisCodes. I need to join these two tables.
>
<snip>