Same Table join using alias

i need to join like ,
select
from tab_a
left join tab_b on a.id-b.id
left join tab_c on b.id=c.id
left join tab_a_rep on c.another_id=a.id

is it possible?
tab_a_rep is the another table with underlying same topic as tab_a. r using alias

ksqlDB 0.19 will ship with FK-joins… Should be released soon.

1 Like

Hi,
I see ksql 0.19 being released.
Will this release , support my same table join .
I can see FK join (fk from left = pk from right) feature.

in my case i need to use same table twice, so?

Hi @mjsax ,
Also now joins are working like many : 1. (fk_lefttable= pk_righttable)
is der any workaround for it to support like tab1 Leftjoin tab2 on (pk_lefttable =fk_righttable)

There is no “left-join” for 1:n, because there is not “right-join” for n:1… ksqlDB cannot support this atm.

Check out this blog post, that explains why we only support n:1 left-join: https://www.confluent.io/blog/data-enrichment-with-kafka-streams-foreign-key-joins/

thank you @mjsax for the info

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