List:General Discussion« Previous MessageNext Message »
From:Baron Schwartz Date:February 9 2009 9:30pm
Subject:Re: Updatable view using subquery??
View as plain text  
> 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 :-)
Thread
• Updatable view using subquery??blue.trapezius9 Feb
  • Re: Updatable view using subquery??Baron Schwartz9 Feb
  • Re: Updatable view using subquery??Jochem van Dieten9 Feb
    • Re: Updatable view using subquery??Baron Schwartz9 Feb