Hello!

This frame of code get sintax error.
Which is the correct sintax ?

SELECT Tipo__CF,;
CodiceCF,;
CodiceAR,;
DataUlAV AS DataUAcq,;
ValoreAV;
FROM UAV A;
INNER JOIN (SELECT CodiceAR, MAX(DataUlAV) FROM UAV GROUP BY CodiceAR) B ;
ON A.CodiceAR = B.CodiceAR ;
INTO CURS _UAV_Ultimo_ ;
ORDER BY A.CodiceAR

Thanks
Hi

On Thu, 6 May 2004 17:55:10 +0200, "mathasu78" <wendynet (AT) libero (DOT) it> wrote:
[ Courtesy cc'ed through e-mail to the quoted author ]

I believe it should be "SELECT <fields> FROM <source> INTO <target>" and _then_
all other stuff.
--
[ When replying, remove *'s from address ]
Alexandre Peshansky, Systems Manager, RUH, NY