FW: RE: MSSQL to MySQL mapping

2005-08-22 Thread John ccccc
Also mysql complaints when I use the *= syntax: select a.userID from USers a, UserGroups b where a.UserGroupID*=b.UserGroupID; Any ideas? What is the equivalent syntax for MySQL. Thank you John C> From: "John c" <[EMAIL PROTECTED]> To: mysql@lists.mysql.com Subjec

FW: RE: MSSQL to MySQL mapping

2005-08-22 Thread John ccccc
I am trying to adjust sql_mode but with no success. I use MySQL Query Browser from a remote mashine, login as root and I run set global sql_mode='ansi'; Then I run MySQLCommand line client from the MySQL server and the sql_mode is unchanged. I also tried to set the sql_mode in the My.ini f