SELECT a.users.name,c.users.year_of_birth
  FROM vsam://mvs.a.biz/USERDATA.APPNAME.FILEFMMF(XXXXXXXX)
         AS a,
       m204://mvs.b.biz/USERDATA.APPNAME.FILEFMMF(XXXXXXXX)
         AS b,
       db2mvs://mvs.c.biz/DB2/APPNAME/FILEFMMF/XXXXXXXX
         AS c
 WHERE     a.users.id = b.users.id
       AND b.users.x  = c.users.x