I have two tables in Firestore. Users and threads. I am trying to display a page that shows the user profile image next to the thread. I don't see how I can reference the list in the query, the most I can get is where it shows the document reference. Tried another way to query it in the list output (row by row each one would have to query the table) and that causes an error.
I feel like I am missing something here. The only thing I can some up with is you can't join data in nosql databases. So, when the record is created I could attach the profile image to the record (but then what if that updates) - I guess you could search for and loop through records to update them.
In SQL I want to do something like this: select * from thread left outer join user
I just want the info from both tables.
Is this possible using Firestore?
