How can I union tables and then apply a where filter? basically i want to find all items with the operation_Id == X
Asked
Active
Viewed 4,959 times
4

John Gardner
- 24,225
- 5
- 58
- 76

Leonardo
- 10,737
- 10
- 62
- 155
1 Answers
7
You can do this by specifying the tables for a union.
union table1, table2 | where operation_Id == "X"

James Davis - MSFT
- 1,736
- 10
- 12