In today’s post we will look at the
unionwill create a result set that combines data from two or more tables into a single result set.
join, which was covered in my previous post Fun With KQL – Join, the
uniondoes not combine the columns from each table into single rows. Rather it returns rows from the first table, then rows from the second table, then if supplied third, forth and so on.
Read on to see how
union works as an operator and for several examples.