>Nadya,
>
>You didn't specify which cCode to use.
>
>
SELECT ..., LOOKUP(Towns.county, curTemp.ccode, Towns.ccode, 'ccode') AS MyCounty ...
Thanks. I'll try that tomorrow (if I have time, of course :)) and compare the speed.
If it's not broken, fix it until it is.
My Blog