As KQL is designed for this sort of task and used by some of the analytical tools that come together in ... you can use union or join statements to work with multiple tables at the same time.