>Hi Sergey.
>I am getting a error saying something like incorrect index or something similar(i am using chinese fox, sorry for not translating right. ) I used the exact SQL you reply with but somehow it doesnt seem to work...

Id it "SELECTs are not UNION compatible (Error 1851)"? If it's not, what is error number?