Question

Why is it that SELECT TOP 10 (awin_image_r + awin_image_i) as saveme FROM des_dr1.main doesn't work but SELECT TOP 10 (awin_image_r - awin_image_i) as saveme FROM des_dr1.main , where the plus sign has been changed to a minus sign, does work using the web query interface?

Answer 1

This has been fixed. Please try it again.

Comments

This still doesn't work:
 SELECT TOP 10 (awin_image_r + awin_image_i) as saveme FROM des_dr1.main
And this still does:
SELECT TOP 10 (awin_image_r - awin_image_i) as saveme FROM des_dr1.main

---

This also works:
SELECT TOP 10 (awin_image_r - awin_image_i*-1) as saveme FROM des_dr1.main
Should I just multiply numbers by -1 and subtract when I want to add.
This seems a bit kludegy to me.  I'd have thought parser would know about addition.

---

Could you refresh the webpage and try it again?