This content has been marked as final. Show 4 replies
Just write the Join Condition the same way you would do it on SQL statement, and it will works.
(t1.a1=t2.a2 or t1.b1=t2.b2)
(t2.c2=t3.d2 or t2.d2=t3.d3)
A. Drieux answered your first question, so I'll do the second one.
if b1 and c2 are null (only a1 and d2 given), T1 will be correctly joined to T2 through a1-a2 and T1 will also be correctly joined to T3 through d2-d3.
Same when only b1, c2 are provided ;)
Hope it helps.
Thanks a lot
Do not hesitate to mark helpful posts as helpful ;)