Can't merge anything in level 2 workflow 1

Getting Started with n8n n8n Courses
1

Hi there, I am doing course level 2 but having a problem.
I follow the part 1 description, but the merge node always get nothing output.

Embedded the setting json and screenshot.

image
image1119×610 70.7 KB

Could anyone help please?

2

I use the “SQL Query” mode and it works.
But if I use the “Combine” mode and set the Output Type to “Enrich Input 1 (left join)” it didn’t work correct.

image
image1624×904 105 KB

SELECT * FROM input1 LEFT JOIN input2 ON input1.customerID = input2.customerID