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