I have a file of address and a file of sewer permits. My users would like to see the sewer permit # for each address, but not all addresses have sewer permits. If they set up a query with data from both tables I would assume they will only get records where there is a join. Is my assumption correct? Is there any way to give them a list of all addresses that don't have a sewer permit?

(I know how to do these things in my hand coded reports/queries)

Jack