Drag queries into places
Double click the union query
Pick which one will be included in our final query
- You can use this technique for except and intersect too.
They operate by join the appropriate row. So Query 1 first row data item will be unioned / intersected / excepted with data item on Query 2 first row data item, and so on.