Most efficient way to filter

I’m working on optimizing a dataset.
Is it more efficient to filter my data by doing an inner join, or to do a left join then add a filter on the worksheet?

Our data guru recommended that I do an inner join if that gets me the results I want.