SELECT p.PLUCode, p.PLUDescription,p.Text2,p.Text3,p.Text4,p.tuc,p.Active, s.SummationDescription, l.LabelDesignCode
FROM dbo.vw_df_plu_file p LEFT JOIN dbo.dcs_summations s ON p.PLUID = s.PLUID LEFT JOIN dbo.dcs_summations_label_designs l ON s.SummationID = l.SummationID
WHERE s.SummationDescription = 'Case' ORDER BY p.PLUCode