How to create a single table in a snippet from multiple data blaze tables

Questions and Help
1

Can you help me with the snippet syntax to do the following?

I have a datablaze space called "FFP," with three tables: 2024, 2023, 2022.
Each table has the same fields (columns) representing tax return information such as "total income," and "tax rate."
Each table contains rows with client names, "Taxpayer Name(s)" , although each name may not have data in all three tables.

I would like to create a snippet that:

  • Prompts the user with a drop-down box containing a non-duplicative list of all taxpayer names in the three tables.
  • Then pulls data across the three tables for that taxpayer (ie, columns for each of the three tables, 2024, 2023, 2022 and the same rows for each table.
    Something like this:

John and Mary Smith 2024 2023 2022
Total income 50,423 72,345 68,349
Total tax 18,223 16,897 12,330
etc.
etc.

2

Here is a small bundle that fetch from 3 different tables in a single space. It then merges all names into a single unique list and passes that into a dropdown. Once a single client selected, it will display relevant data from all three tables.

{dbselect: SELECT Name, Count FROM `2023`; space=id; multiple=yes; name=all2023}
{dbselect: SELECT Name, Count FROM `2024`; space=id; multiple=yes; name=all2024}
{dbselect: SELECT Name, Count FROM `2025`; space=id; multiple=yes; name=all2025}
{all=merge(all2023, all2024, all2025)}
{unique_names=unique(map(all, client->client.name))}
{formmenu: values={=unique_names}; name=client_name}
2023: {=map(filter(all2023, client->client.name={=client_name}), client->client.count)}
2024: {=map(filter(all2024, client->client.name={=client_name}), client->client.count)}
2025: {=map(filter(all2025, client->client.name={=client_name}), client->client.count)}