From: Aldred on
Hi Stefan,
Access complained that syntax error in join. Will that be the problem of
having no "AS"?

Let me try to put "AS" in and see if it works.

Thanks.

"Stefan Hoffmann" <ste5an(a)ste5an.de> �b�l��
news:ObL5xAS5KHA.5880(a)TK2MSFTNGP04.phx.gbl �����g...
> hi Aldred,
>
> On 26.04.2010 08:35, Aldred(a)office wrote:
>> Can some one please help in pointing me what's wrong?
> Try this:
>
> SELECT *
> FROM tPart oP
> INNER JOIN tCharge oC
> ON oC.partNumID = P.ID
> WHERE oC.ChargeDate =
> (
> SELECT Max(iC.ChargeDate)
> FROM tCharge iC
> INNER JOIN tPart iP
> ON iP.ID = iC.partNumID
> WHERE iP.ID = oP.ID
> )
>
>
>
>
> mfG
> --> stefan <--