What is the syntax for UNION?

Nkekere_Tommy_Minimann · January 25, 2021, 9:59am

What is the syntax for doing sql style UNION on two or more tables?

olhadanylova · January 25, 2021, 10:05am

We do not support UNION.
Could you please provide more information about what do you want to do and, we’ll try to help you.

Regards,
Olha

mark-piller · January 25, 2021, 11:16am

Hi Nkekere,

The closest to UNION we have is this:

Regards,
Mark

Nkekere_Tommy_Minimann · January 25, 2021, 1:45pm

There are 9 tables a user can post to. When the user wants to search for all their posts I want to build a search query like this: Retrieve all posts from user in tableA + tableB + tableC +… Sorted by date of post

mark-piller · January 25, 2021, 2:17pm

With this database design, you’d need to make 9 queries.