Merging the results of 2 queries into 1 return

Hi all,

See the loom: https://www.loom.com/share/58f57de8c13f4d21bea66ef3a7828184?sid=5874ca57-5e7f-4eae-af81-6e71919536c5

I want to return a list of events that have been created by my friends or that my friends are participating in.

I query two tables. The events table brings back anyone who is my buddy (via inner join) and has created an event, while the event participants table brings back anyone who is my buddy (also via inner join) and is a participant in an event.

However, I am facing a challenge in merging these two lists into one so they ca then be returned in chronological order.

3 replies