You can add the diag_code table to the report as many times as you need and left join it to the client_diag table each time on each colum (primary, secondaty, tertiary... or axial, axis 1, axis 2 axis 3 or both). It will alias the table name by adding a 1, 2, 3 after the table name each time you add it. Make sure to left join it each time becasue I am guessing your clients may or maynot have a matching diag on inserted into each column.