1 SELECT cm_firstname, cm_lastname, parent_cmid 

     2 FROM identitytable 

     3 WHERE cm_type=268440329

     4 ORDER BY cm_firstname, cm_lastname;