Whats wrong with my query!!!

[Saint]

Using Oracle 9 and Toad

SELECT * FROM charts.flow WHERE UserID in ('3','4');

doesn't work..... I get "Table doesn't exist" although I can look at the schema and see Charts DB and flow table. I even copied them instead of typing to make sure no typing flaws.

Still didn't work. I'm using Toad to do all this by the way.

Next, I did the "Query Builder" where you actually select the databases and tables from a selection chart which built the exact same query!!!! This same query works fine in the Oracle 8 database. Any ideas?

[Chrisms]

is Charts capitalized? if it is, and you're on a *nix server, you need to be case sensitive.

[Jordan]

Try using quotes around the table name. I've seen Oracle 9 behave this way.

SELECT * FROM "charts.flow" WHERE UserID in ('3','4');