Gives error when executing this query in the system that generates reports

Asked

Viewed 38 times

0

Error executing this query in the report system, but directly from the database returns right>

ERROR>>> ORA-00942: table or view does not exist Stijdbcdatabase

The consultation is a very simple:

SELECT cd_ord_com, dt_ord_com, cd_especie, ds_especie FROM ord_com, especie

sql database oracle mysqli

  • Isn’t this query missing data? Check the crossings between the tables?

  • You would not have to specify which field is from each table and what is the relationship between them?

  • Is the query being executed in the correct database? This error comes from this.

  • This error occurs : 1) the table does not exist , 2) exists but in another Wner , qualify Wner.table or create a public synonym , 3) without permission

No answers

Browser other questions tagged sql database oracle mysqli

You are not signed in. Login or sign up in order to post.