Hi Mohammed,

The following code worked for me. What version of FoxPro are you using? Is Authors a FoxPro DBF or some other Database Source?

Gavin...

>it did not work
>
>
>SELECT UPPER(au_lname) AS au_lname ;
> FROM authors ;
> GROUP BY au_lname ;
> HAVING COUNT(*) > 1 ;
> INTO CURSOR firstpass_cursor
>
>SELECT authors.* ;
> FROM firstpass_cursor, authors ;
> WHERE UPPER(authors.au_lname) = firstpass_cursor.au_lname ;
> INTO CURSOR secondpass_cursor ;
> ORDER BY firstpass_cursor.au_lname
>
>ERRORS ARE
>
>Server: Msg 156, Level 15, State 1, Line 2
>Incorrect syntax near the keyword 'FROM'.
>Server: Msg 156, Level 15, State 1, Line 8
>Incorrect syntax near the keyword 'FROM'.
>
>
>Thanks Mohammed