Using Oracle 9 and Toad
Code:
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?