Select
  pd.PUID                As DataSetPuid,
  RelStat.PNAME          As DataSetReleaseState,
  RelStat.PDATE_RELEASED As DataSetReleaseDate
From
  infodba.PDATASET pd,
  infodba.PRELEASE_STATUS_LIST RelStat_List
Inner Join infodba.PRELEASESTATUS RelStat
On
  RelStat.PUID = RelStat_List.PVALU_0