How to cross join KsqlDB tables or streams?

I want to cross join 2 KsqlDB Tables. For example:

Country Table

data_id country
101 Malaysia
102 Singapore

Product Table

data_id product
301 pen
302 book

The result should be:

Country_Product Table

country_data_id country product_data_id product
101 Malaysia 301 pen
101 Malaysia 302 book
102 Singapore 301 pen
102 Singapore 302 book

I tried to google the solution, but I have no luck. All information that I found are inner join or outer join only.

This topic was automatically closed after 30 days. New replies are no longer allowed.