> > Add an alias for the subquery > > select * from ( select .... ) my_alias where dd >= 3; > > Better, use a having clause and eliminate the subquery. Odds are it > will be more efficient in MySQL. >
How to replace the original one with a having statement?
Thanks again.
Get the name you always wanted with the new y7mail email address.
www.yahoo7.com.au/y7mail
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
