Hi
I am able to create an updatable view using a subquery in MySQL 5.1.29
mysql> CREATE VIEW v_aa AS
-> SELECT *
-> FROM flight AS f
-> WHERE f.RouteID IN
-> (SELECT r.RouteID
-> FROM route AS r
-> WHERE r.To=
-> (SELECT a.AirportID
-> FROM airport AS a
-> WHERE a.AirportCode='SIN')
-> )
-> ORDER BY FlightID DESC;
Query OK, 0 rows affected (0.02 sec)
mysql> insert into v_aa
-> values (1,1141,3145);
Query OK, 1 row affected (0.00 sec)
But according to the MySQL manual, "a view is not updatable if it contains
any of the following:...subquery in the select list". I am quite confused by
this. Can someone help me understand the details of this?
TIA