It is possible to join Transfers and Transactions in one query?

I need to receive all transactions by the address, and mark them by the “Type of transaction”.
In my aplication i’d like to use “Type of transaction”: “Native transfer”, “ERC20 transfer”, “Others”.
Now i can reques all kind of the transaction at first request.
Then on second request i can request all transfers with transaction hash and inside my aplication compare transaction hashes and mark some of transactions as “Native transfer” and “ERC20 transfer”.

In SQL I can easily do such things at DB level using join inside query.
It is possible to use something like join at bitquery to make just one transaction for my task?

I believe this question was asked on telegram as well. Here’s the query native & non-native transfers ERC-20

Let me know if this helps or if it is something else entirely