# Kintone REST Api Join Operations **URL:** \ **Category:** General\ **Created:** [August 10, 2020, 2:57pm UTC](https://forum.kintone.dev/t/kintone-rest-api-join-operations/336 "2020-08-10T14:57:01Z")\ **Posts on this page:** 2\ **Page:** 1
**Author:** ![legacy\_user](https://yyz1.discourse-cdn.com/flex035/user_avatar/forum.kintone.dev/legacy_user/32/25_2.png) [@legacy\_user](https://forum.kintone.dev/u/legacy_user)\ **Post date:** [August 10, 2020, 2:57pm UTC](https://forum.kintone.dev/t/kintone-rest-api-join-operations/336/1 "2020-08-10T14:57:01Z")
Can you run join operations (inner join, left join, etc) between 2 kintone tables using the rest api? Or if you’ve set up related records on a table is there a way to return the related fields in the records.json api response? Thanks! ---
**Author:** ![legacy\_user](https://yyz1.discourse-cdn.com/flex035/user_avatar/forum.kintone.dev/legacy_user/32/25_2.png) [@legacy\_user](https://forum.kintone.dev/u/legacy_user)\ **Post date:** [August 12, 2020, 9:12pm UTC](https://forum.kintone.dev/t/kintone-rest-api-join-operations/336/2 "2020-08-12T21:12:54Z")
Hello Sean, \>Can you run join operations (inner join, left join, etc) between 2 kintone tables using the rest api? It is not possible to do so since kintone does not have an INNER JOIN, OUTER JOIN, etc. functions. It is a bit of a process, but please use the GET RECORD API to retrieve the data from both tables, create a table in the target app, and place the retrieved values in the created table.   Get Record: [https://developer.kintone.io/hc/en-us/articles/213148957-Get-Record](https://forum.kintone.dev/hc/en-us/articles/213148957-Get-Record)   \>Or if you’ve set up related records on a table is there a way to return \>the related fields in the records.json api response?   I think the only way to do this is to get the records from the reference source via API.   Hopefully, this helps.