Not returning all

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

cmichaud@ufl.edu - 06 Apr 2006 18:49 GMT

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

Reply to this Message

Tom Ellison - 06 Apr 2006 19:03 GMT

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

> This is what my sql for the query looks like.
>
[quoted text clipped - 13 lines]
> does that make sense?
> any ideas....would love some help

Reply to this Message