Hello! I'm trying to use Microsoft Query (from MS Office 97) with MySQL 3.23.33 via MyODBC 2.50.36. (MySQL runs on a FreeBSD 4.3RC machine) It sometimes works, but often MySQL reports strange errors about inexistants tables or fields names. Often, in MySQL log file, I see something like "select dummy.foo dummy_0.foo from dummy dummy_0" where dummy is my table name and foo is my field(s) name. What's that "_0" (underscore zero) that it sometimes add ? I tried manually from mysql console login and it works ! It does not report errors like "table name not existant". But, if in MSQuery I try to use a "WHERE" clause it always uses the "_0" and MySQL complains ! What the "_0" represents, and why it's used ? I saw that MySQL accepts sometimes and refuses it other times. Does someone is successfully in using MSQuery with MySQL ? Any hint is welcome! :) Thanks a lot ! Alessandro de Manzano Playstos - TIMA S.p.A. Corso Sempione 63 20149 Milano, Italy tel.: +39-023314153 fax: +39-02315678 email: [EMAIL PROTECTED] http://www.playstos.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php