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

I knew because you closed the table in your first code snippet :)

After the SELECT, USE IN rostKode will do the trick...