# Data From Multiple Tables

**URL:** <https://forum.bubble.io/t/data-from-multiple-tables/171788>\
**Category:** Database\
**Created:** [September 30, 2021, 11:21am UTC](https://forum.bubble.io/t/data-from-multiple-tables/171788 "2021-09-30T11:21:45Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![mustafa.ali](https://avatars.discourse-cdn.com/v4/letter/m/ecd19e/32.png) [@mustafa.ali](https://forum.bubble.io/u/mustafa.ali)\
**Post date:** [September 30, 2021, 11:21am UTC](https://forum.bubble.io/t/data-from-multiple-tables/171788/1 "2021-09-30T11:21:45Z")

</div>

Hello,

I am working on a application where I have multiple tables (data types), and I need to create a report where I can show the data from multiple table and do some operations on it like add and substract and show in the repeating group, how can this be done in bubble?

For Example:-

I have a table A with attributes, ID, Item Code and Quantity,  
and table B with same attributes:- ID, Item Code and Quantity

Now I want to show the quantity per Item Code in the repeating group

so, Table A has Item Code:- 11011010 and Quantity:- 500, Item Code:-22022020 and Quantity:- 1500  
And Table B has Item Code:- 11011010 and Quantity:- 1000, Item Code:-22022020 and Quantity:- 2500

So the repeating group needs to show:-

Item Code :- 11011010 and Quantity:- 1500  
Item Code :- 22022020 and Quantity:- 4000

Hope I was able to explain the problem

can someone help me in this?

---

<div class="post-metadata">

**Author:** ![tony.villiams](https://avatars.discourse-cdn.com/v4/letter/t/97f17d/32.png) [@tony.villiams](https://forum.bubble.io/u/tony.villiams)\
**Post date:** [June 23, 2022, 12:47am UTC](https://forum.bubble.io/t/data-from-multiple-tables/171788/2 "2022-06-23T00:47:25Z")

</div>

@mustafa.ali - were you able to get answer to this ? ran into a similar issue and looking for a solution

---

<div class="post-metadata">

**Author:** ![Titus](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/titus/32/164241_2.png) [@Titus](https://forum.bubble.io/u/Titus)\
**Post date:** [July 1, 2022, 5:37pm UTC](https://forum.bubble.io/t/data-from-multiple-tables/171788/3 "2022-07-01T17:37:26Z")

</div>

I don’t know if you still need help with this, but I would create a summary table, where we combine the quantities from Table A and Table B, and update them based on a database trigger when an Item’s quantity changes. Then you can pull the repeating group from the new table
