SELECT 
  dbo.DataSet_tbl.DataSetName,
  dbo.DataSet_tbl.DataSetIrRelation,
  dbo.DataSet_tbl.DataSetType,
  dbo.Ir_tbl.IrNameRev,
  dbo.Ir_tbl.IrRev
FROM
  dbo.DataSet_tbl
  INNER JOIN dbo.DataSet_Ir_Rel_tbl ON (dbo.DataSet_tbl.Id = dbo.DataSet_Ir_Rel_tbl.DataSetId)
  INNER JOIN dbo.Ir_tbl ON (dbo.DataSet_Ir_Rel_tbl.IrId = dbo.Ir_tbl.Id)
WHERE
  dbo.DataSet_tbl.DataSetType = 'UGPART'
ORDER BY
  dbo.DataSet_tbl.DataSetName
