MySQL Forums
Forum List  »  Microsoft Access

Re: MySql and MsAccess views
Posted by: Federico Razzoli
Date: October 11, 2004 05:08PM

Anyway, there is a workaround. In 4.1 you can use a subquery as a view:
SELECT * FROM (SELECT ...) WHERE ... ORDER BY ... LIMIT ...

This feature is called "derived tables". You should also be able to use nested "derived tables".

Options: ReplyQuote


Subject
Views
Written By
Posted
3214
August 30, 2004 06:49AM
2197
September 26, 2004 09:58AM
Re: MySql and MsAccess views
2215
October 11, 2004 05:08PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.