title: Multiple keys or Foreign keys in KSQL
body: <p>How can i perform 1 -> N relation in KSQL  </p>
  
  <p>I am having one table with bob_id as primary key, there is another table which will have multiple Rows with foo_id as primary key and bob_id as foreign key.  </p>
  
  <p>How can i use KSQL to replicate this situation ?  </p>
  
  <p>As far as i can see KSQL does not have Foreign key. </p>
  
  <p>And we cannot join tables in ksql unless the column is primary key. </p>
  
  <p>Repartition does not work as i am using table not streams. </p>