SELECT copy."barcode" AS "Barcode",
 acqlid."cancel_reason" AS "Cancel Reason"
  FROM acq.lineitem_detail AS acqlid
 INNER JOIN asset.copy AS copy ON (acqlid."id" = copy."id")
  WHERE copy."deleted" = 'f'
 AND copy."barcode" LIKE '%ACQ%'
  GROUP BY 1, 2
  ORDER BY copy."barcode" ASC, acqlid."cancel_reason" ASC