Hi, I try to execute the following select and it doesn't work. The problem is that I have to make a select using 2 tables from 2 different databases. Could anyone tell me how to do that with jdbc ? the select:
the JDBC instruction:
the error message
Internal Servlet Error: javax.servlet.ServletException: S0022: 'codutl' is an incorrect colum name.
Thanx in advance, Slim Dasch
posted 15 years ago
So far as I know, you must work with the tables over separate JDBC connections, one for each database, and concatenate the results. Also, this question has been asked before; try searching the forum for "two tables" to see some relevant results.