> I think what you want is "CREATE VIEW test.v AS SELECT * FROM t;"
That will do the job, thank you. -- Richard Heyes http://www.phpguru.org -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]