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.
Part 2 of a series on Context Variables
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema