I want to join four tables as following screenshot. I want to pick the rows in TABLE2, 3, 4 if their IDs are match with TABLE1, and left join those qualified table. How should I do?
I tried this:
[TABLE1 left join TABLE2 left join TABLE3 left join TABLE4 ], but it didn't show the product0002 and 0003. Also, don't use WHERE ID='0001''0002''0003', cause the original dataset is too big to type all the ID manually.
