Create a union table

After creating a custom table, you can merge its data with other queries to create a union table. When merging a custom table with an already existing query, the fields of the custom table whose name matches those in the query are automatically merged. The rest of them will appear as not assigned, and you can merge them with the custom table fields of the same type.

The following diagram represents how the merging process works:

Open

To merge a custom table with a query: