An doubt about mysql version 4.0.x agains 4.1.x

2004-03-05 Thread Luiz Rafael Culik Guimaraes 
Dear Friend

an friend of mine told that the follow line bellow dont work with mysql
version 4.0.x

* Support for subqueries and derived tables
This mean query like : SELECT A.* FROM (SELECT * FROM TESTE WHERE X = Y) A
WHERE COL1 = 3

is this true, or mysql version 4.0.x work properly with this

Regards
Luiz



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: An doubt about mysql version 4.0.x agains 4.1.x

2004-03-05 Thread Victoria Reznichenko 
Luiz Rafael Culik Guimaraes [EMAIL PROTECTED] wrote:
 Dear Friend
 
 an friend of mine told that the follow line bellow dont work with mysql
 version 4.0.x
 
 * Support for subqueries and derived tables
 This mean query like : SELECT A.* FROM (SELECT * FROM TESTE WHERE X = Y) A
 WHERE COL1 = 3
 
 is this true, or mysql version 4.0.x work properly with this
 

It's true. The above SELECT statement will work only from 4.1.


-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Victoria Reznichenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   ___/   www.mysql.com





-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]