Steve,

VFP doesn't support derived tables. Try to run internal select as a separate query into a cursor and than join it with main query.

>Sergey:
>
>Thanks it seems to work perfect with SQL Server. I trying to tie out two systems. One written with SQL Server and One with FoxPro. This code seems to work only with SQL. i guess foxpro doesn't support the type of join that you provided.
>
>Any idea's on how to solve this in SQL with Foxpro. I know I can scan through a table, but I'd rather use SQL statements.
>
>Thanks,
>Steve