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

**URL:** <https://community.bitquery.io/t/it-is-possible-to-join-transfers-and-transactions-in-one-query/1814>\
**Category:** GraphQL API\
**Created:** [January 11, 2024, 6:23pm UTC](https://community.bitquery.io/t/it-is-possible-to-join-transfers-and-transactions-in-one-query/1814 "2024-01-11T18:23:32Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Mitch](https://avatars.discourse-cdn.com/v4/letter/m/dec6dc/32.png) [@Mitch](https://community.bitquery.io/u/Mitch)\
**Post date:** [January 11, 2024, 6:23pm UTC](https://community.bitquery.io/t/it-is-possible-to-join-transfers-and-transactions-in-one-query/1814/1 "2024-01-11T18:23:32Z")

</div>

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?

---

<div class="post-metadata">

**Author:** ![Divya](https://avatars.discourse-cdn.com/v4/letter/d/13edae/32.png) [@Divya](https://community.bitquery.io/u/Divya)\
**Post date:** [January 15, 2024, 5:25am UTC](https://community.bitquery.io/t/it-is-possible-to-join-transfers-and-transactions-in-one-query/1814/2 "2024-01-15T05:25:03Z")

</div>

I believe this question was asked on telegram as well. Here’s the query [native & non-native transfers ERC-20](https://ide.bitquery.io/native--non-native-transfers-ERC-20)

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