I need a solution for an innerjoin problem

another innerjoin problem

Thanks in advance