Joined: 15 Sep 2008
Location: United States
Online Status: Offline
Posts: 2
Topic: Selecting with null or no record in other table Posted: 15 Sep 2008 at 12:33pm
It's probably easier to go over my problem than try to describe it...
Simple two table query. A person table and an emailaddress table. I'm trying to select all people who are flagged as active ( based on field in the person table). The active people may have multiple email addresses. Possible types are business or personal.
I want the report to only show the business address. But when I run into a record in the person file with out a record in email table with type=business that person doesn't show on the report if I select email_type=BUS
But if I don't put that in I get multiple report lines with both the personal and business email addresses.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum