I writing a java application for the Cloudscape database using two different databases I get these errors noting that both FLIGHTS exists as a column in database 1 and that the table CL_SCHED exists as a table in database 2 the following strings are the queries that create these errors, I am using the derby cloudscape driver and not sure if its a driver issue something wrong with my sql statements or ..... Also noting that a full query on the FLIGHTS table returns a correct resultset of that table.
string 1 : SELECT FLIGHTS FROM FLIGHTS
string 2 : SELECT * FROM CL_SCHED
Database 1 : SQL Exception: Column 'FLIGHTS' is not in any table in the FROM list or it appears within a join specification and is outside the scope of the join specification or it appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE statement then 'FLIGHTS' is not a column in the target table.
Database 2 : SQL Exception: Table 'CL_SCHED' does not exist
stmt = conn.createStatement();
rslSet = conn.executeQuery();