Nope - pretty much bang on. Use the join, with sorted inputs, and left outer it.

For the inverse, you can use a lookup component.

To open an old can of worms, stay away from Where not in. It's non-sarg query and will hurt. Google it 🙂