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
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
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
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