SQL standards?

Hi,

we currently try to develop an application, which is capable to work with different databases. The interface is ADO.
The problem is that the some providers (native ADO Access 2000, SQL Server, ODBC for MySql,...) behave different in the SQL syntax, they accept. For example in a SQL-join, some providers accept a field name only with addiotional leading table name, while others accept them only without.

Is there any standard, what SQL syntax will be accepted by any provider?

Thanks,

Christian

give this book a look

http://www.oreillynet.com/pub/a/netw...oracleian.html

will