From: Martijn Tonies Date: December 15 2003 9:18am Subject: Re: CREATE VIEW List-Archive: http://lists.mysql.com/mysql/155695 Message-Id: <013b01c3c2ec$623e0d10$0e02a8c0@martijn> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Hi, > I can't find this syntax in mysql tutorial and the program does not accept > it. Well, that should give you a hint, shouldn't it? > Is there another method of achieving this ? Views are going to be supported in MySQL 5, I believe. With regards, Martijn Tonies Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL Server. Upscene Productions http://www.upscene.com