How can I keep a table from limiting my query results?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am pulling tables out of Lotus Database to create reports. The issue I am
having is that some tables have data for a specific record and some do not.
For example, all of my locations have transaction data, however only a few of
them have any robbery data because they have not been robbed. But when I
write a query to show all of my locations with transaction and robbery data,
I am limited to only the few that have robbery data. I know that I need to
change my relationships to keep this from happening, but I am not sure
exactly how. Any suggestions? Thank you in advance for your help.
 
Back
Top