Use Multiple Join Conditional

Anonymous — Sat, 16 Nov 2024 02:23:55 GMT

I need to create a rule using two tables with two fields

To do this, I want to use the conditional join option (shown in the attached image EXAMPLE1)

When I create this it gives me the following error (shown in the attached EXAMPLE3 image)

To solve this problem, I make a where clause (shown in the attached image EXAMPLE2)

Could you explain the correct way to do it using the conditional join option?

I don't understand the reason why it doesn't allow to use conditional join option when I want to use a join on two tables and two fields. The function in SQL should be as follows:

SELECT * FROM CGET06 CGET06 LEFT JOIN CEMT007 CEMT007 ON CGET06.CSUBZONA = CEMT007.CSUBZ AND CGET06.CZONA = CEMT007. CZONA

Thank you

topic Use Multiple Join Conditional in Data Quality

Use Multiple Join Conditional