SELECT PM.GUID, PM.PID,
       PM.MISCID,
       CAST((PM.YEAR) AS NUMERIC) AS THEYEAR
  FROM PMASTER PM
              INNER JOIN SEL SL
              ON SL.LGID = PM.PID
 ORDER BY PM.PID,
          THEYEAR

1244    1    21    2013
3444    1    21    2014
9888    1    21    2015
3244    3    45    2014
5144    3    45    2015
6588    3    45    2016
3324    6    73    2014
5454    6    73    2015
6758    6    74    2016

9888    1    21    2015
6588    3    45    2016
6758    6    74    2016