Syntax for nest JOIN in MS Access?

[mike1reynolds]

This query works:

SELECT p.AcntNumber, p.Name, d.FromDate
FROM Daysheet AS d
INNER JOIN Patient AS p ON d.AcntNumber=p.AcntNumber

But this does not:

SELECT p.AcntNumber, p.Name, d.FromDate, c.CPT
FROM Daysheet AS d
INNER JOIN Patient AS p ON d.AcntNumber=p.AcntNumber
INNER JOIN Charge AS c ON c.Id=d.ChargeNum

Nor this:

SELECT p.AcntNumber, p.Name, d.FromDate, c.CPT
FROM Daysheet AS d
(INNER JOIN Patient AS p
(INNER JOIN Charge AS c ON c.Id=d.ChargeNum)
ON d.AcntNumber=p.AcntNumber)

How do you word a nested join?

 

[WayneRyan]

Mike,

SELECT p.AcntNumber, p.Name, d.FromDate, c.CPT
FROM   Daysheet AS d INNER JOIN Patient AS p[B] ON [/B]
         d.AcntNumber = p.AcntNumber INNER JOIN Charge AS c ON 
           c.Id = d.ChargeNum

Wayne

 

[ByteMyzer]

See below (note the placement of the parenthesis):

SELECT p.AcntNumber, p.Name, d.FromDate, c.CPT
FROM (Daysheet AS d
INNER JOIN Patient AS p ON d.AcntNumber=p.AcntNumber)
INNER JOIN Charge AS c ON c.Id=d.ChargeNum