Hello Steve,
>Did it work when you tried it? :)
>
>Seriously, it should...except the rostKode table will still be in use after the select, and you may want to close it if that is a problem.Well, I'm just tinkering in SQL and was asking what should have been obvious to me. Your second comment about the rostKode table still being in use was my next question (how did you konw??). All I have to do is find the ALIAS() or work area, and close it. Thanks for the info.
Randy Bosma
VFP - Because life is too short to code in something else...