Currently, you can only perform stream-table joins (stream: left, table: right). We should support stream-stream joins, too, similar to what Kafka's Streams API already supports.
Related tickets:
table-table joins also should be supported.
@IDispose and @pouledodue : Please cast your +1 vote to the separate table-table join ticket that I just created: https://github.com/confluentinc/ksql/issues/760
Fixed by #1417
Most helpful comment
table-table joins also should be supported.