Campbell is right.
Actually everyone knows the exact SQL which runs on Oracle or SQL Server.
Actually SQL Server 7 and above and Oracle support ANSI 92 version of SQL while MS Access continues to use ANSI 89 version which is different from theone we all know. So if ur making a db and writing queries in Access and u ever plan to upgrade to SQL server or Oracel, u'll b dead ......... i'll find u writing queries agian.
But if u want to stay with the standard, fortunately it is possible to tell Access to start supporting ANSI 92
You can do this by
1. Click Tools menu and select Options
2. Click on Tables/Queries Tab
3. In SQL Server Compatibility Syntax area, check the checkbox named "This Database", and then start making ur database.
If u already have a database made and queries written, better not do this, as it may effect ur existing queries and will cause them to stop running.. better to do this with a DB ur starting to make or backup the copy of ur db b4 taking this step
but working with ANSI 92 will b benefitted definitely in future.
Enjoy!!!!