It is better to use LEFT join with the drag and drop options since a Custom SQL will always create a sub-query.
After that you can use filter in your worksheet .
OR FILTER AT DATA SOURCE ITSELF (BETTER )
Go to data-source and click on the Filters (Top RHS ---See below )
Please mark the answer as CORRECT & HELPFUL if it really helped you so that it can help others.