>Hello!
>My company curently use microsoft SQL, we discover the MySQL database few
>weeks ago and we really impressed, but i have a few problems becouse my
>querys use the union select which is not acceptet by MySQL, for example:
Sir, it would be a bad idea to continue trying to convert your SQL
Server database to MySQL without first reading the manual and
understanding the differences. If your database is complex, or your
client apps use many complicated queries, it would be a very bad idea
to continue without reading the manual. There are many differences
between Transact-SQL and the MySQL dialect of SQL. (Every RDBMS uses
its own dialect of SQL.)
As far as UNION is concerned, I suggest waiting for version 4 of
MySQL. V4 will have UNION and subselects, two of the most important
differences between the two RDMBSs. Waiting for v4 will make the
conversion a lot easier. You will still need to read the manual to
understand the differences.
BTW, the workaround for UNION is in the manual.
Bob Hall
Know thyself? Absurd direction!
Bubbles bear no introspection. -Khushhal Khan Khatak
---------------------------------------------------------------------
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
