Help with SQL
I have a small problem, I have to codify a query SQL that runs as much in Access, SQL_Server and oracle, since the application with which I am working can use anyone of those three data bases, does anybody can help me to codify a query that can unify in a single one so that it runs in any data base.
The best solution for your problem is to aplied the DAO (Data Acces Object) path instead of trying to make a question that works for all.
Here's the sun link about J2EE patches and in particular DAO:
Core J2EE Patterns - Data Access Object