Ksqldb how to join with multiple condition

[patharapon]

Hi,

how to join multiple Condition on ksqlDB

Example data

Create stream C as select 
a.id1,
a.id2,
a.username,
a.name,
a.birthdate,
b.id1,
b.id2,
b.username,
b.lastname
From a
Join b **on** a.id1 = b.id1 **AND** a.username =  b.username **OR** a.id2 = b.id2;