An Inner Join on an Inner Join

Tech-Archive recommends: Fix windows errors by optimizing your registry

In an M2M relationship between headers and quads I
wish to select the header keys & names where the header record
contains both of two quadkeys (CKey) from the join table, tblQuadsJoin.

I've been trying to do this with an inner join on an inner join
but the SQL below doesn't work.

SELECT tblHeaders.HKey, tblHeaders.Name
FROM tblHeaders
(INNER JOIN tblQuadsJoin
ON tblHeaders.HKey = tblQuadsJoin.PKey
WHERE tblQuadsJoin.CKey = 61)
INNER JOIN tblQuadsJoin
ON tblHeaders.HKey = tblQuadsJoin.PKey
WHERE tblQuadsJoin.CKey = 84

Am I on the right track or do I need to build an intermediate table
based on the first join and then do the second join on the intermediate table?

Thanks, Dave
.

Relevant Pages

  • Re: find value from a query
    ... Use [Max Classification] in the header. ... cboClassification are secret, confidential, FOUO and unclass. ... FROM tblStatusChoices INNER JOIN (tblPersonnel INNER JOIN (tblNumbered ...
    (microsoft.public.access.reports)
  • Re: Report Queries
    ... Would it be feasible to use the AttendeeID in the group header? ... field in the CaseNumber header that shows in design view. ... FROM ((TPhysicians INNER JOIN Attendees ON TPhysicians.TPhysicians = ...
    (microsoft.public.access.queries)
  • Re: Report Queries
    ... By moving all the fields into the header area, it allows for the grouping to ... showing each page in the query. ... Would it be feasible to use the AttendeeID in the group header? ... FROM ((TPhysicians INNER JOIN Attendees ON TPhysicians.TPhysicians = ...
    (microsoft.public.access.queries)
  • Re: find value from a query
    ... Use [Max Classification] in the header. ... cboClassification are secret, confidential, FOUO and unclass. ... FROM tblStatusChoices INNER JOIN (tblPersonnel INNER JOIN (tblNumbered ...
    (microsoft.public.access.reports)
  • Re: Report Queries
    ... In report design, you can now see a section headed by a grey bar named: ... Would it be feasible to use the AttendeeID in the group header? ... FROM ((TPhysicians INNER JOIN Attendees ON TPhysicians.TPhysicians = ...
    (microsoft.public.access.queries)