Hey Teo,
So what we have is a transaction history for a single web3 wallet address.
Their transaction history is stored in two different tables. The items they are buying, are entirely different from each other so there is no common id, or common link between the two.
I want to output the transaction history of both tables into one output I can then show on the F/E.
Example:
TXN Table 1:
id
item_name
description
price
txn
item_id (linking to that specific purchases table)
TXN Table 2
id
collection_name
description
price
txn
item_id (linking to that specific purchases table)
the item_id is not a common link between the two, as they themselves are separate tables with unique information.
So the goal here would be to have a single output:
id
name (which would be either item_name or collection_name)
description
price
item_type (e.g. type one, or type two)
date etc.