Thank borislav
SELECT COUNT( RECNO() ) , 'Résidants Présents dont :' FROM (AMLINE!Resident AS 'R';
LEFT OUTER JOIN AMLINE!Etats AS 'E' ON R.iid = e.iresidentid ) WHERE ;
ISNULL( e.iid )= .F. AND e.ltransfert= .F. AND e.dfin <> {} AND TTOD( r.dsortie ) = {} AND;
e.iid IN ( SELECT MAX( B.iid ) FROM AMLINE!Etats AS 'B' WHERE B.iresidentid = e.iresidentid ) INTO CURSOR TEMP1
>Remove ORDER BY in Your SubQuery:
>
>
>SET ENGINEBEHAVIOR 80
>SELECT COUNT( RECNO() ),;
> e.iid FROM (AMLINE!Resident AS 'R';
> LEFT OUTER JOIN AMLINE!Etats AS 'E' ON R.iid = e.iresidentid );
> WHERE e.iid IN ( SELECT B.iid FROM AMLINE!Etats AS 'B' WHERE B.iresidentid = E.iresidentId GROUP BY B.iid)
>
>
>
>>Hi all,
>>
>>I have a error 1300 in my sql command.
>>Function name is missing
>>
>>
>>I do'nt see what happend..
>>5VFP 8.1 SET BEHA 80
>>
>>
>>SET ENGINEBEHAVIOR 80
>> SELECT COUNT( RECNO() ) , e.iid FROM (AMLINE!Resident AS 'R';
>> LEFT OUTER JOIN AMLINE!Etats AS 'E' ON R.iid = e.iresidentid ) WHERE ;
>> e.iid IN ( SELECT B.iid FROM AMLINE!Etats AS 'B' WHERE B.iresidentid = E.iresidentId GROUP BY B.iid ORDER BY B.iid )
>>
>>
>>
>>Thank in advance for help
>>
>>bernhart