How to combine data in table?

App Building
1

Without using a join, is there a way to combine data from multiple tables into one table?
I have a Posts table that contains different types of image, text, link, and video posts. Each post’s content data is stored in an Image, Text, Link table etc, linked by the Post ID.
I would like to be able to display the attached data in the same table. Is there an easy way to do this?
Thanks!

2

Hey! Yes you should be able to do this. Just for more context – why would a join not work here?

3

There are multiple tables and it could get really messy. I was wondering if there was another way besides joining on every single post type.

4

You could do the join using Javascript in a Transformer (docs here: https://docs.retool.com/docs/transformers), but I think it would definitely be cleaner to do it in SQL

5

Thanks, that’s good to know