I'm having a lot of trouble getting my SQL queries to work with an ODBC connection even though they work from Access when linking the ODBC tables. I know Access uses JET, but what standard does ODBC use? I have the ODBC DSN setup on my Windows 2003 Data Sources. Is there a standard that all ODBC SQL queries should work. None of my complicated queries work, like nested SELECT statements with table aliases. I appreciate any help in helping me find some guidelines to follow.