Prev: 回覆: Select Max, return unwanted rows.
Next: ComboBox related query
From: Aldred on 28 Apr 2010 01:37
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 <--

 | 
Pages: 1
Prev: 回覆: Select Max, return unwanted rows.
Next: ComboBox related query