title: KSQL: Invalid join condition: foreign-key table-table joins are not supported as part of n-way when joining more than 2 Table
body: <p>I have 3 topics with KAFKA_INT key</p>
  <p>customer,orders,orderdetails</p>
  <p>When i do joining 2 tables only</p>
  <pre><code>
  select * from orders o join customer c on o.custid = c.custid emit changes; -- OK 
  
  select od.id, od.orderid from orderdetails od join orders o on od.orderid = o.orderid emit changes; -- OK
  
  
  -- NOT OK
   
  select * from orderdetails od
  join order o on od.orderid = o.orderid
  join customer c on o.custid = c.custid
  emit changes limit 5; 
  
  -- Error
  Invalid join condition: foreign-key table-table joins are not supported as part of n-way joins. Got o.custid = c.custid.
  
  </code></pre>
  <p>However, I couldn't find any documentation how can multiple tables join work and what is the limitation of it.</p>
  <p>I am using Confluent KAFKA HELM version 7.0</p>