SQL with V4MD and viSQL

[Holly Bogossian]

I have had no problems with simple SQL using executeSQL command but 
cannot get the following to work. I keep getting the error:  "603, 
Field Not Found". Same result regardless of operator. What am I doing 
wrong?

     SELECT (field1Number - field2Number) FROM baseObjectName

Using Director MX, V4MD v1.10 on Mac G4. This same result also occurs 
using viSQL on WinXP.
Thanks
--holly
-- 
---------
The cure for anything is salt water -- sweat, tears, or the sea.
       --isak dinesen