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