translating MS access Database query to KNIME

Hi guys!

I’m trying to translate MS Access queries to KNIME. can someone explain to me how to translate this specific query? so far I have only done 2 correlations so its just a joiner node but this time it is 3 tables corellating.

also, what does the “Is Null Or” function mean?

thank you!