Employee Personal Transfer (All Workgroups)

SELECT
    E.IDNUM,
    E.LASTNAME + ', ' + E.FIRSTNAME + ' ' + E.INITIAL AS EmployeeFullName,
    CASE WHEN ET.WG1 = 0 THEN 'No Transfer / Home WG1' ELSE W1.NAME END AS Workgroup1Name,
    CASE WHEN ET.WG2 = 0 THEN 'No Transfer / Home WG2' ELSE W2.NAME END AS Workgroup2Name,
    CASE WHEN ET.WG3 = 0 THEN 'No Transfer / Home WG3' ELSE W3.NAME END AS Workgroup3Name,
    CASE WHEN ET.WG4 = 0 THEN 'No Transfer / Home WG4' ELSE W4.NAME END AS Workgroup4Name,
    CASE WHEN ET.WG5 = 0 THEN 'No Transfer / Home WG5' ELSE W5.NAME END AS Workgroup5Name,
    CASE WHEN ET.WG6 = 0 THEN 'No Transfer / Home WG6' ELSE W6.NAME END AS Workgroup6Name,
    CASE WHEN ET.WG7 = 0 THEN 'No Transfer / Home WG7' ELSE W7.NAME END AS Workgroup7Name,
    ET.RATE,
    ET.EFFDATE,
    CASE
        WHEN ET.FLAGS = 0 THEN 'Replacement'
        WHEN ET.FLAGS = 1 THEN 'Addition To'
        WHEN ET.FLAGS = 2 THEN 'Multiplcative Factor'
        WHEN ET.FLAGS = 3 THEN 'No Change'
    END AS RateFlagDescription
FROM
    EMPTRANRATES ET
    INNER JOIN
    EMPLOYEES E ON ET.FILEKEY = E.FILEKEY
    LEFT JOIN WORKGROUP1 W1 ON ET.WG1 = W1.WGNUM AND ET.WG1 <> 0
    LEFT JOIN WORKGROUP2 W2 ON ET.WG2 = W2.WGNUM AND ET.WG2 <> 0
    LEFT JOIN WORKGROUP3 W3 ON ET.WG3 = W3.WGNUM AND ET.WG3 <> 0
    LEFT JOIN WORKGROUP4 W4 ON ET.WG4 = W4.WGNUM AND ET.WG4 <> 0
    LEFT JOIN WORKGROUP5 W5 ON ET.WG5 = W5.WGNUM AND ET.WG5 <> 0
    LEFT JOIN WORKGROUP6 W6 ON ET.WG6 = W6.WGNUM AND ET.WG6 <> 0
    LEFT JOIN WORKGROUP7 W7 ON ET.WG7 = W7.WGNUM AND ET.WG7 <> 0
WHERE
    E.ACTIVESTATUS = 0
ORDER BY
    EmployeeFullName;