Information générale
Titre:
SFReports Outer Join type things
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
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement