# Display a table containing data from multiple database tables

**URL:** <https://forum.adalo.com/t/display-a-table-containing-data-from-multiple-database-tables/27765>\
**Category:** Database\
**Created:** [May 30, 2022, 11:57am UTC](https://forum.adalo.com/t/display-a-table-containing-data-from-multiple-database-tables/27765 "2022-05-30T11:57:35Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![clareenergy](https://avatars.discourse-cdn.com/v4/letter/c/aca169/32.png) [@clareenergy](https://forum.adalo.com/u/clareenergy)\
**Post date:** [May 30, 2022, 11:57am UTC](https://forum.adalo.com/t/display-a-table-containing-data-from-multiple-database-tables/27765/1 "2022-05-30T11:57:35Z")

</div>

Hello all,

I would like to display a table that aggregates data from multiple database tables.

In my example I have a table of users with 3 fields e-mail, phone, name  
I also have a table of houses with 2 fields address, postcode. Each user can have one or more houses.  
I also have a table of solar installations with 3 installationsize, installationcost and installer. Each house can have one or more solar installations.

I’d like to generate a table (just for my view) where I can see all of the 8 fields above in an 8 column table.

Is this possible in Adalo ? If there is a freelancer who offers the paid service of doing this example in direct with me, I’m willing to sign up.

Best regards / Colm

---

<div class="post-metadata">

**Author:** ![Rozza](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/rozza/32/22780_2.png) [@Rozza](https://forum.adalo.com/u/Rozza)\
**Post date:** [May 30, 2022, 12:21pm UTC](https://forum.adalo.com/t/display-a-table-containing-data-from-multiple-database-tables/27765/2 "2022-05-30T12:21:31Z")

</div>

Make a custom list of ‘Installations’ you can then reference the parent collections to populate your 8 column table fully.

If you need help beyond this then feel free to drop me a message.

---

<div class="post-metadata">

**Author:** ![clareenergy](https://avatars.discourse-cdn.com/v4/letter/c/aca169/32.png) [@clareenergy](https://forum.adalo.com/u/clareenergy)\
**Post date:** [May 31, 2022, 12:09pm UTC](https://forum.adalo.com/t/display-a-table-containing-data-from-multiple-database-tables/27765/3 "2022-05-31T12:09:50Z")

</div>

Hello Rozza,

Thanks for the pointer. Would you be open to giving a coaching session, one hour perhaps, at some point this week ? I think it would be the most useful for me. I can pay via Stripe , Resolut or whatever suits.

Best regards / Colm

---

<div class="post-metadata">

**Author:** ![Rozza](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/rozza/32/22780_2.png) [@Rozza](https://forum.adalo.com/u/Rozza)\
**Post date:** [May 31, 2022, 12:30pm UTC](https://forum.adalo.com/t/display-a-table-containing-data-from-multiple-database-tables/27765/4 "2022-05-31T12:30:50Z")

</div>

It would be my first. so let’s say enough for a coffee if it helps you 😃

I will DM you

---

<div class="post-metadata">

**Author:** ![Flawless](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/flawless/32/20131_2.png) [@Flawless](https://forum.adalo.com/u/Flawless)\
**Post date:** [May 31, 2022, 12:39pm UTC](https://forum.adalo.com/t/display-a-table-containing-data-from-multiple-database-tables/27765/5 "2022-05-31T12:39:40Z")

</div>

It is doable for sure. I know you’re already speaking with @Rozza about this and I’m not trying to step on Rozza’s toes here but I offer mentoring sessions to help with situations exactly like this.

Rozza’s offer for a cup of coffee is a great deal, definitely more than I charge 😂

So if/when you’re ready, here are the details: [One-on-one Adalo Mentoring 💎](https://forum.adalo.com/t/one-on-one-adalo-mentoring/27024)