>>I wish that when examples are shown, people would keep them as simple as possible. Why a long select statement followed by a cryptic filename (or in this case, cursor)? When not , , etc...to make it obvious that we are talking different names. I personally don't have time to go through the logic of a long select statement and be picky about filenames, variable names, etc...I want to look quickly, see if I can help, and move-on...now, you might want to say "Well, if you don't have time to give a question the proper attention, don't get involved", but my point is still valid: Keep it simple and clear. More people will take the time to give it a look and it increases your chances of getting a good answer and it decrease your chances of confusion.
>
>Joe, while it's easier to read a simplified restatement of the problem, sometimes it's the little details that have tripped up the person. Also, you have to remember that what is difficult for you to read, "maxlønn" or "andreprodukt" is as clear to Per as "MaxLength" and "OtherProduct" would be to us (and I'm guessing at the Norwegian, here, folks, please don't be rude if I'm way off).
>
>SELECT statements are particularly apt to have one clause wrong or a parenthesis is the wrong place because they are so complex.
>
>Barbara


Thanks Barbara for your answers!

I think Vlad gave me the right clue, to use "use again in 0 alias somename."
I changed my code in all the places I have used again in 20 again in 21 again in 22 and so on..
This way everything is working.

And by the way "maxlønn" is maxsalary the other word you guest right.

Next time I will try to keep my question shorter!

Im sorry for my late reply, the reason is that since the 28.11 and up today I spent a short holyday in St.Petersburg Russia.
I brought my computer with me but my celluarphone card (GSM) was not supported. So no internett access!

Best regards

Per Simmersholm