Search results

I'm trying to make a query where data from two tables that are joined. However, some entries have data from only one table and some have data from both tables. The query is returning only the results that have data in BOTH tables. Is there a way to circumvent this and just return nothing for...