I have a MS SQL query that queries multiple views. The query is something like this
SELECT main.id, main.name, lvl1.id, lvl1.name, lvl2.id, lvl2.name, sub.sub_id FROM main LEFT JOIN level lvl1 ON lvl1.id = main.level1_id AND lvl1.level = 1 LEFT JOIN level lvl2 ON lvl2.id = main.level2_id AND lvl2.level = 2 LEFT JOIN sub_main sub ON sub.level_1_name = lvl1.name AND (sub.level_2_1_name = lvl2.name OR sub.level_2_2_name = lvl2.name)
I am able to code the first two LEFT JOINs in a tMap component.
I am not sure how to do the last one, especially the OR part of the JOIN.
Can anyone help me with this?
Solved! Go to Solution.
perhaps you can use this: Omit the OR condition in the query and put it as a filter condition in the output table in tMap.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema
Pick up some tips and tricks with Context Variables