# Retrive data to update record (like SQL JOIN)

**URL:** <https://community.tulip.co/t/retrive-data-to-update-record-like-sql-join/5624>\
**Category:** Support, Troubleshooting, & Help\
**Created:** [June 22, 2022, 8:51am UTC](https://community.tulip.co/t/retrive-data-to-update-record-like-sql-join/5624 "2022-06-22T08:51:56Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Bigagnoli](https://avatars.discourse-cdn.com/v4/letter/b/58f4c7/32.png) [@Bigagnoli](https://community.tulip.co/u/Bigagnoli)\
**Post date:** [June 22, 2022, 8:51am UTC](https://community.tulip.co/t/retrive-data-to-update-record-like-sql-join/5624/1 "2022-06-22T08:51:56Z")

</div>

Hello,

I have an application where i need to fill table column with data from another table.

Here an example:

Table A

ID  
Column A  
Column B

Table B  
ID  
Column B  
Column C

I need to search in Table B using a non ID field (Column B) that is present in both table. In the end i have to copy Column C into Column A

How can i do it inside a trigger?

Thanks

---

<div class="post-metadata">

**Author:** ![RussWaddell](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tulip.co/russwaddell/32/3774_2.png) [@RussWaddell](https://community.tulip.co/u/RussWaddell)\
**Post date:** [June 22, 2022, 4:28pm UTC](https://community.tulip.co/t/retrive-data-to-update-record-like-sql-join/5624/2 "2022-06-22T16:28:17Z")

</div>

Take a look at the knowledge base article for modifying tables: [How To Modify Tables Within the App Editor | Tulip Knowledge Base - Support for Building Operations Apps](https://support.tulip.co/en/articles/2989793-how-to-modify-tables-within-the-app-editor)

I think what you’re looking for is under “Loading Existing Records” if I understand your case correctly. Especially the section on using a variable in a trigger.