I have a lot of processes where what I am really looking for is a

LEFT JOIN

but I can't do it in searches, so I have to do a lot of extra steps to accomplish the same goal