Combining Data from Multiple Sources

This section provides a tutorial on combining data from multiple sources.

After completing this tutorial, you will be able to:

• Write a Query statement that combines information in a data stream with information in a window.

• Describe the equivalent syntax choices available for combining stream and window data.

• List and compare three different ways of combining stream and window data.

• Before Beginning the Combining Data Tutorial
  Before you begin the activities in this tutorial, be sure you have access to the following:
• Joining a Stream to a Window
  In this activity you will be combining a stream that represents a request for information with a window containing trade information in order to provide the price and time of the most recent trade for the specified stock symbol.
• Executing the Join
  Examine the results of the join.
• Exploring Join Variations: Exercise
  Explore how the output of the join query changes when you change the join condition or alter other statements in your project.
• Creating an inner join: Exercise
  Explore different syntax for an inner join.
• Creating an outer join: Exercise
  How to create output joins even when the join condition isn't met.
• Combining data tutorial: Conclusion
  Summary of the several kinds of inner and outer join queries.
• Solutions
  Solutions to the join exercises.