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)?
>>SELECT * FROM mytable >> WHERE mytable.linkfield IN (SELECT linkfield FROM othertable WHERE test = testvalue)>>do the trick?