>Can anyone suggest me that is it possible to create view with >"order by" >clause...
This is not possible. Views are Sets/Relations that have no sort order. Sorting is applicable only to cursors. If you want only a 'canned query', then you could create a stored procedure that executes the select. But the results of a stored procedure call cannot be used in other queries. Daniel Dittmar -- Daniel Dittmar SAP Labs Berlin [EMAIL PROTECTED] -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
