Hello, my question has to do with inner joins and nulls.

The question is, how would i need to modify an inner joins search query to return all fields even if a table is null. So basically, if I have two tables that have matching values and a third table that is completely null or doesn't have those values, I still want it to return those matching values.

I also don't have any experience with this so please describe it...