> Your subquery is not in the select list, it is in the where. A > subquery in the select list would be: > CREATE VIEW v_aa AS > SELECT > * > , (SELECT MAX(x) FROM y) AS z > FROM flight > > This is not updatable because there is no sensible way to propagate > changes to the y base table.
Great catch :-) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org