问是否有一种方法可以从两个单独的表中各返回一个变量，但只有当每个表中的两个变量匹配时才返回？

EN

WITH
  bonds_table AS(
    SELECT
      DATE_TRUNC('day', "call_block_time") AS "Day",
      "_depositor" AS Wallet,
      sum("output_0") / 1e18 AS "dexSHARE Redeemed"
    FROM
      dexfinance."wBNB_bond_for_dexshare_call_redeem"
    WHERE
      "call_success" IS TRUE --Verify transaction was successful
    group by
      1,
      2
  ),
  --This table is for sales of the tokens
  sales_table AS(
    SELECT
      derivedTable1."Day",
      derivedTable1."to" AS Wallet,
      sum(derivedTable1."amountIn" / 1e18) AS "dexSHARE Sold"
    FROM
      -- This combines the sales from both tables so they can be summed
      (
        SELECT
          DATE_TRUNC('day', "call_block_time") AS "Day",
          "amountIn",
          "to"
        FROM
          pancakeswap_v2."PancakeRouter_call_swapExactTokensForETH" -- This table is for tokens to wBNB
        WHERE
          "path" [1] = '\xf4914e6d97a75f014acfcf4072f11be5cffc4ca6' -- Sale of dexSHARE
          AND call_success is TRUE -- Verify transaction was successful
          AND "call_block_time" >= TO_TIMESTAMP('2022-05-24', 'yyyy-mm-dd')
        UNION
        SELECT
          DATE_TRUNC('day', "call_block_time") AS "Day",
          "amountIn",
          "to" AS Wallet
        FROM
          pancakeswap_v2."PancakeRouter_call_swapExactTokensForTokens" -- This table is for tokens to other tokens (not wBNB)
        WHERE
          "path" [1] = '\xf4914e6d97a75f014acfcf4072f11be5cffc4ca6' -- Sale of dexSHARE
          AND call_success is TRUE -- Verify transaction was successful
          AND "call_block_time" >= TO_TIMESTAMP('2022-05-24', 'yyyy-mm-dd') -- Sales after this date (launch of Bond)
      ) AS derivedTable1
    GROUP BY
      1,
      2
  )
SELECT bo."Day",bo."Wallet" ,bo."dexSHARE Redeemed",dexSHARE Sold"
FROM bonds_table bo JOIN sales_table sa ON sa."Wallet2  = o."Wallet"  AND sa."Day" = bo."Day"