Thanks Rich, it most certianly does do the trick.

I must track down the help file for VFP 6 so I can check what is and isn't possible.

Regards
Geoff Scott

>>Hi
>>
>>in version 9 I can code

SELECT mytable.* ;
>>	FROM (SELECT linkfield FROM othertable WHERE test = testvalue GROUP BY linkfield) as tLink ;
>>		INNER JOIN mytable ON tLink.linkfield = mytable.linkfield

>>which is really fine. Is it possible to achieve the same result in version 6 (odbc)?
>>
>>regards
>>Geoff Scott
>
>Does
>

>SELECT * FROM mytable
>  WHERE mytable.linkfield IN (SELECT linkfield FROM othertable WHERE test = testvalue)

>do the trick?