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