I know, I know...The column shouldn't be named "NUMBER", but it was here before I was, and I can't change it for now. At the moment, I only have read access to this database, and I was told it would be changed...soonish...
I've tried referencing it as
Table."NUMBER" and that works when querying directly from Oracle, but for some reason, I still get the infamous
ORA-01747: invalid user.table.column, table.column, or columns specification error when I reference it that way in MS Query. I also tried
'Table."NUMBER"', but each of these gave me an error from MS Query saying it wasn't expecting the punctuation in the select column list.
Does this have something to do with the way MS Query handles double quotes? Is there any way to make sure that the double quotes around NUMBER make it to Oracle without MS Query throwing an error?
My query is really simple...except for this part.
Select Table."NUMBER" From Table
Thanks in advance for any help.