What is FPW? (Foxpro?)
Geoff
>>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?
May all your weeds be wildflowers