Thanks!

>>Hi All:
>>
>>Can you help me with this code? What's wrong with this syntax?
>>
>>

>>SET STRICTDATE TO 0
>>
>>SELECT MAX(flocknum) FROM ;
>>(SELECT SUBSTR(fm_flcode,5,4) flocknum ;
>>FROM flckmast ;
>>WHERE fm_hatched <= {4/1/07} ;
>>AND fm_hatched >= {3/1/07} ;
>>) ;
>>INTO CURSOR test
>>

>>
>
>You need to give the derived table a local alias. That is, provide a name for it after the closing paren.
>
>Tamar