Not returning all

  • Thread starter Thread starter cmichaud
  • Start date Start date
C

cmichaud

This is what my sql for the query looks like.

SELECT tblPersonalInfo.MemberID, tblPersonalInfo.LastName,
tblPersonalInfo.FirstName, tblMemberAllergy.AllergyID,
tblMemberAllergy.Notes
FROM tblPersonalInfo INNER JOIN tblMemberAllergy ON
tblPersonalInfo.MemberID = tblMemberAllergy.MemberID
WHERE
(((tblPersonalInfo.MemberID)=[forms]![frmindividual]![memberID]));


my problem is that if a member doesnt have an allergy when i run the
query none of the info will come up....no name or anything. in
actuallity this query will be much longer as i have a lot of related
tables. starting small to figure it out. anyhow i want it to return
ANY of the info....not just if the record has all the entries.
does that make sense?
any ideas....would love some help
 
Dear CMichaud:

Change INNER to LEFT

Study the topic of joins to learn the details of this. Also, in the query
Design View, right click on the line between the tables that is the
relationship in question. The properties of this show you 3 choices, which
are the INNER, LEFT, and RIGHT JOIN possibilities. The text there spells
out the differences.

Tom Ellison
 
Back
Top