SELECT "D6"."memberUniqueName2" AS "memberUniqueName2",
       "D7"."Adjustment_Amount" AS "Adjustment_Amount"
FROM
  (SELECT DISTINCT "D_CREDIT_ALERT8"."CREDIT_ALERT_NUMBER" AS "memberUniqueName2"
   FROM "DM_Sales"."dbo"."D_CREDIT_ALERT" "D_CREDIT_ALERT8") "D6",
  (SELECT SUM("F_INVOICE_ADJ9"."REQUEST_AMOUNT") AS "Adjustment_Amount"
   FROM "DM_Sales"."dbo"."F_INVOICE_ADJ" "F_INVOICE_ADJ9" HAVING COUNT(*) > 0) "D7"