Help with SQL

[Felissa]

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.

Felissa

[Marcus]

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

Marcus