# Joining linked Fields in a API rows request

**URL:** <https://community.baserow.io/t/joining-linked-fields-in-a-api-rows-request/6047>\
**Category:** Uncategorized\
**Created:** [September 9, 2024, 7:09am UTC](https://community.baserow.io/t/joining-linked-fields-in-a-api-rows-request/6047 "2024-09-09T07:09:22Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![systemaddict](https://community.baserow.io/letter_avatar_proxy/v4/letter/s/eb9ed0/32.png) [@systemaddict](https://community.baserow.io/u/systemaddict)\
**Post date:** [September 9, 2024, 7:09am UTC](https://community.baserow.io/t/joining-linked-fields-in-a-api-rows-request/6047/1 "2024-09-09T07:09:22Z")

</div>

Hi

I’ve got three tables in my Soccer App:

Players (individual players)  
Teams (teams where I link to the Players table so I can select who is on Team x,y,z)  
Events (Tournaments where I link to Teams, so I can see which teams are playing)

Now, ideally I would like to get all information about Events in a single call, but I’m struggling with getting the Players.

I can do this:

/api/database/rows/table/634/?user\_field\_names=true&Hold\_\_join=Name

But then I only get the Team and if I try to include the Players as well “&Hold\_join=Name,Spillere” I will get an ERROR\_INCOMPATIBLE\_FIELD\_TYPE

 ![image](https://community.baserow.io/uploads/default/original/2X/1/1a4286a4ad2d8afa2156b4e11527f3168e0217f6.png)

I suppose this is happening because Players (Spillere) is a linked field.

Any way to solve this without resorting to making two calls and join in code?

---

<div class="post-metadata">

**Author:** ![petrs](https://community.baserow.io/user_avatar/community.baserow.io/petrs/32/159_2.png) [@petrs](https://community.baserow.io/u/petrs)\
**Post date:** [September 9, 2024, 8:32am UTC](https://community.baserow.io/t/joining-linked-fields-in-a-api-rows-request/6047/2 "2024-09-09T08:32:12Z")

</div>

Hi @systemaddict,

you are right - it is not possible to join a link to table field in this way. What you can probably do is to add a proper lookup field there and ask for that instead. Would that solve your problem?

---

<div class="post-metadata">

**Author:** ![systemaddict](https://community.baserow.io/letter_avatar_proxy/v4/letter/s/eb9ed0/32.png) [@systemaddict](https://community.baserow.io/u/systemaddict)\
**Post date:** [September 9, 2024, 9:45am UTC](https://community.baserow.io/t/joining-linked-fields-in-a-api-rows-request/6047/3 "2024-09-09T09:45:25Z")

</div>

I did try that, but I can add more Teams to an Event and ideally the Players should be grouped below each Team.

If I create a lookup field it will fetch all Players I think.

Does this make sense?

---

<div class="post-metadata">

**Author:** ![petrs](https://community.baserow.io/user_avatar/community.baserow.io/petrs/32/159_2.png) [@petrs](https://community.baserow.io/u/petrs)\
**Post date:** [September 9, 2024, 9:53am UTC](https://community.baserow.io/t/joining-linked-fields-in-a-api-rows-request/6047/4 "2024-09-09T09:53:50Z")

</div>

It is not possible to do any nesting adhoc lookups via `join`s. When using `join` the results are basically nested only 1 level deep. However creating a proper lookup field in `Teams` into the `Players` table and then requesting that field via `join` from `Events` could make the result you are after perhaps?

---

<div class="post-metadata">

**Author:** ![systemaddict](https://community.baserow.io/letter_avatar_proxy/v4/letter/s/eb9ed0/32.png) [@systemaddict](https://community.baserow.io/u/systemaddict)\
**Post date:** [September 9, 2024, 9:56am UTC](https://community.baserow.io/t/joining-linked-fields-in-a-api-rows-request/6047/5 "2024-09-09T09:56:14Z")

</div>

That actually worked. Thanks 🙂
