Waiting for v5 for views, you can prepare them in inline view (subqueries):
select ... from (select ...)
Selon Duncan Hill <dhill@stripped>:
> On Monday 23 May 2005 20:01, Dayakar wrote:
> > Please give me solutions at the earliest as mirgration from oracle to mysql
> > is started and i need to meet the solution as soon as possible.
> 4.1 does not support views. As documented in the online documentation:
> "Views (including updatable views) are implemented in the 5.0 version of
> Server. Views are available in binary releases from 5.0.1 and up. See Chapter
> 21, Views."
> Migrating, and then reading the documentation and trying to learn how things
> work is usually a bad idea.
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=1