I am familiar with Access only in passing, so the following query may not compile correctly. But the idea is that you need to join on the PupilID as well.SELECT
ps.PupilID,
ps.PupliName,
ps.SubjectId,
ts.Target
FROM
PUPILSSTUDYING ps
INNER JOIN SUBJECTLIST sl ON
sl.SubjectID = ps.SubjectId AND sl.Subject = ps.Subject
INNER JOIN TARGETS ts ON
ts.PupliId = ps.PupilID AND ts.TargetType = sl.TargetType
WHERE
PS.PupilID=1
Inner join problem
Posted - 08/19/2012 : 06:23:31
