Updatable view using subquery??

2009-02-09 Thread blue . trapezius
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

Re: Updatable view using subquery??

2009-02-09 Thread Baron Schwartz
Hi! On Mon, Feb 9, 2009 at 7:17 AM, blue.trapez...@gmail.com wrote: 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

Re: Updatable view using subquery??

2009-02-09 Thread Jochem van Dieten
On Mon, Feb 9, 2009 at 1:17 PM, blue.trapez...@gmail.com wrote: 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

Re: Updatable view using subquery??

2009-02-09 Thread Baron Schwartz
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