>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
>
FWIW.........

This is compatible with FPW2.6 SQL coding. Sometimes it helps to be a dinosaur!!!!





>>>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?