Why is metabase giving this weird error of invalid reference?

Question

SELECT
  count(
    distinct "public"."cnpy_portfolio_current_snapshot"."userid"
  ) AS "count"
FROM
  "public"."cnpy_portfolio_current_snapshot"
  INNER JOIN (
    SELECT
      tenderneutralledgerid as ledgerid,
      userid,
      tnl.merchantprogramid,
      tm.merchantid
    FROM
      tdym_tender_neutral_ledgers as tnl
      INNER JOIN tdym_merchant_programs as tm ON tnl.merchantprogramid = tm.merchantprogramid
      where {{createdat}} 
    UNION
    SELECT
      rewardledgerid as ledgerid,
      userid,
      tm.merchantprogramid,
      tm.merchantid
    FROM
      tdym_reward_ledgers as tl
      INNER JOIN tdym_merchant_programs as tm ON tl.merchantid = tm.merchantid
      where {{createdat}} 
  ) AS "Join all Reward Ledgers - Userid" ON "public"."cnpy_portfolio_current_snapshot"."userid" = "Join all Reward Ledgers - Userid"."userid"
  INNER JOIN "public"."tdym_merchants" ON "Join all Reward Ledgers - Userid"."merchantid" = "public"."tdym_merchants"."merchantid"
 

WHERE {{merchantname}}

I am working on this query, merchantname and createdat are the variables in metabase, but I am repeatedly getting this weird error. Its not just this query, most of the queries i am using feild filter of date variables are giving this error

ERROR: invalid reference to FROM-clause entry for table "ra_orders" Hint: Perhaps you meant to reference the table alias "a".

I tried in various queries but it didn't work.