anchor.diff:  Press Ctrl-C to cancel the output. 
   
   <<<
  -=== Populating a Kafka topic with the results of a Stream-Table join
  +==== Populating a Kafka topic with the results of a Stream-Table join
   
   Let's persist this as an enriched stream, by simply prefixing the query with `CREATE STREAM … AS`:
   
  
positive.code: 
  _This method of creating derived topics is frequently referred to by the acronym of the statement—`CSAS` (-> `CREATE STREAM … AS SELECT`)._
  
  ==== Inspect the derived stream
  
  Using `DESCRIBE` we can see that the new stream has the same columns as the source one.
  
  
negative.code: 
  image::images/ksql_workshop_03.png[Joining data with KSQL]
  
  Remember our Customer data? Let's bring that into play, and use it to enrich the inbound stream of ratings data to show against each rating who the customer is, and their club status ('platinum','gold', etc). 
  
  === Prepare the Customer data 
  
  We're going to model the Customers topic as a **KSQL Table**. This is a semantic construct that enables us to work with the data in the topic as key/value pairs, with a single value for each key. You can read more about https://docs.confluent.io/current/streams/concepts.html#duality-of-streams-and-tables[this here].
  
  ==== Inspect Customers Data
  
  Let's check the data first, using the very handy `PRINT` command:
  
  